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

Hi,

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

So my question is how can I combine an
IF(ISNUMBER(SEARCH("GNT",$E2)),"GNT","") FORMULA
AND

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

Thanks everyone for your suggestions!!!

Best regards,

Jasna