Search for text in multiple columns
 

Hello,

I use the following to search a column for names in a list (Sponsors) and
then print the name to the cell if found, otherwise print "False".

=IF(SUM(-ISNUMBER(SEARCH(Sponsors,A2)))=0,"False",INDEX(Spo nsors,MATCH(TRUE,ISNUMBER(SEARCH(Sponsors,A2)),0)) )

This works great, but I need to expand the search to cover multiple columns.
The columns are not contiguous. I need to search columns A, D, H, L, and P,
for names in the list, for instance, and print the name to the cell if the
name appears in any of these columns.

Is this possible?

Thank you,
Tom

Search for text in multiple columns
 

Slight correction, it searches a cell for a matching value in the list and
prints that matching value if found. I would like to search multiple cells,
so check A2, D2, and so on for a match.

"tommcbrny" wrote:

Hello,

I use the following to search a column for names in a list (Sponsors) and
then print the name to the cell if found, otherwise print "False".

=IF(SUM(-ISNUMBER(SEARCH(Sponsors,A2)))=0,"False",INDEX(Spo nsors,MATCH(TRUE,ISNUMBER(SEARCH(Sponsors,A2)),0)) )

This works great, but I need to expand the search to cover multiple columns.
The columns are not contiguous. I need to search columns A, D, H, L, and P,
for names in the list, for instance, and print the name to the cell if the
name appears in any of these columns.

Is this possible?

Thank you,
Tom