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)
 
Back
Top