Displaying what column a piece of data is in

R

Ronin898

I have 18 lists of names. I am trying to create a function that
searches for a name and returns what column it is in. Is this
possible?

Thanks,

John
 
D

Darren Bartrup

If A1:D1 contains Darren, Dave, Sid & Bill then the formula:

=MATCH("Sid",1:1,FALSE) will return (column) 3.
 
Top