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