Solution needed: tricky look up problem

[sam singha]

HI Friends,

I need this tomorrow. attached is a sheet with 2 set of data. Column A contains text that have people's names which are also located in column C. I need to look up what is the corresponding Site name for each person that is contained in the text of Column A.
Ex. in cell A2 the text has Antonio Vlantis and this name is located in cell D100 so the look up site name for this person is the corresponding value in column F ie IM at Flushing.

I want to excel to search for text in column D fully or partly in text of column A and if it finds a match it should paste the site name of column F against it. Column A is very long and if i did a manual search with items of column D it would take very long.

Hope i explained it properly. ANy quick suggetions.

Thank you in advance.

-Sam

TITLE MODERATED (SirJB7)

 

[SirJB7]

Hi, sam singha!

Checked this yet?
http://chandoo.org/forum/forums/new-users-please-start-here.14/

This in particular:
"Please Don't

• Never title your posts as "Urgent", "Priority" "Immediate". It may be Important to you, but not for rest of the members here. These words will be moderated out."

Regards!

 

[Chihiro]

You can use something like...
=LOOKUP(2,1/SEARCH($D$2:$D$208,A2),$F$2:$F$208)

However, with your set up, there will be some issues.
Ex:
A14 has "**XL-168 FM AT SMITHTOWN-SHARMILEE SHETTY"

D23 has "Dr. Sharmilee Shetty"

Which will not be match, you will need to get rid of "Dr. " from D23 to make it match.

You may want to try Fuzzy Lookup Add-in by Microsoft.
https://www.microsoft.com/en-ca/download/details.aspx?id=15011

 

[vletm]

sam singha
We like these 'URGENT's
... my previous urgent didn't count weekend ... >48hrs
>> There are 'some cases' ... this uses mainly Family name for parameter <<
but You could get some results to C-column
and for reference which row makes 'Site Name' to G-column.
>> Press [ URGENT ] and continue ...

 

[Nebu]

Hi:

May be the following formula.

=IFERROR(LOOKUP(2^15,SEARCH($D$2:$D$208,A2),$F$2:$F$208),"")

Thanks