ExcelBanter - Match Text with List

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Match Text with List (https://www.excelbanter.com/excel-discussion-misc-queries/254542-match-text-list.html)

tommcbrny

Match Text with List

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

Jacob Skaria

Match Text with List

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)

--
Jacob

"tommcbrny" wrote:

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

All times are GMT +1. The time now is 03:21 PM.