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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF(ISNUMBER question 0
combine three if functions 3
Lookup or search using the * character 1
Function to Combine Names and Middle Initital In Various Formats 3
If Functions For Dyanmic Drop List 1
Automatically Combine Cell Contents and Delete Rows 0
Using a vlookup to search multiple criteria for one result? 7
Multiple VLOOKUP in an IF statement 2

Top