Match Text with List

  • Thread starter Thread starter tommcbrny
  • Start date Start date
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
 
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)
 
You must log in or register to reply here.

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

Access Partially match 2 lists 1
Match formula 2
Index/match across multiple columns? 19
Excel Is this possible?? 3
Finding Text within an Array 2
Referencing a named array 1
Check for text in multiple cells 4
Check text in range of cells 2

Back
Top