View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Check for text in multiple cells

You can try the below formula in cell K1

=IF(SUMPRODUCT((MOD(COLUMN(A1:I1),2)=1)*(A1:I1="Bi ll")),"Bill","")

If this post helps click Yes
---------------
Jacob Skaria


"tommcbrny" wrote:

Hello,

I would like to check multiple cells for a name and, if the name appears in
any of them, print that name to the destination cell. For instance, columns
A, C, E, G, and I contain names. I want to check A1, C1, E1, G1, and I1 for
"Bill" and, if "Bill" is present in any of the, print "Bill" in K1. Each
name should only appear in one of the columns in a row, so if "Bill' is in
C1, it won't be in A, E, G, or I 1.

Can this be done?
Thanks
Tom