Write a VLOOKUP formula for multiple lookup values

[Vignesh M]

Dears,

Please refer the attached file. I require a formula to write down "YES" or the Keyword in the column "B". The formula should do lookup with column "A" with the lookup value available in the column "F". The real challenge is the formula should match the text available in the Keyword column since the keyword is not the exact value available in the column "A".

Eg: Cells in Column "B" should be "YES" if the corresponding value available in column "A".

Please help me.

Thanks,
Vignesh M

 

[rahulshewale1]

hii @Vignesh M ,


see if is ok ?

=IF(ISLOGICAL(SEARCH(F$2,A2)>0),"yes",IF(ISLOGICAL(SEARCH(F$3,A2)>0),"yes",IF(ISLOGICAL(SEARCH(F$4,A2)>0),"yes","")))



Regard
Rahul shewale

 

[NARAYANK991]

Hi ,

See the attached file for two more options.

Narayan

 

[Naresh Yadav]

Hi,

Pls see if this works for you

=IF(SUMPRODUCT(--ISNUMBER(SEARCH($D$2:$D$4,A2)))>=1,"Yes","No")

regards
Naresh

 

[bosco_yip]

Or.............

=IF(SUMPRODUCT(COUNTIF(A2,"*"&F$2:F$4&"*")),"Yes","")

Regards
Bosco

 

[Vignesh M]

Thanks to all for your awesome support... All the given suggestions are working fine, you people are my inspiration. Thanks again