Match Text with List

T

tommcbrny

Hi, I would like to check a cell to see if the name in it matches one of the
names in a list. If so, I would like to print the name in the cell
containing the formula. If not, I would like to print something else, like
"False". Is this possible?
Thanks,
Tom
 
J

Jacob Skaria

With name list in ColA and query name in cell B1 try the below formual in
cell C1.

=IF(ISNA(MATCH(B1,A:A,0)),"False",B1)
 

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

Check text in range of cells 2
vlookup + if formula help! 7
Access Partially match 2 lists 1
Check for text in multiple cells 4
Index/match across multiple columns? 19
in an Excel database, comparaison between two columns with "almost"the same names => how to search i 1
MATCH 2
Match formula 2

Top