How do I combine IF(ISNUMBER(SEARCH and VLOOKUP( formulas

J

jasna

Hi

Can someone please suggest a formula to combine an if statement and vlooku
formula? I have a database of names, I need to compare a column that contains
string of text to the list of names in a range and return the name within th
string of text that is found in the names database. It will be even mor
helpfu
if the formula can return all the hits from the names database, not just th
first one

So my question is how can I combine a
IF(ISNUMBER(SEARCH("GNT",$E2)),"GNT","") FORMUL
AN

VLOOKUP($E5,'[First Names Database.xlsx]Prenoms'!$B$3:$B$38,1,FALSE) FORMULA

Thanks everyone for your suggestions!!

Best regards

Jasna
 
Top