Displaying what column a piece of data is in

  • Thread starter Thread starter Ronin898
  • Start date Start date
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
 
If A1:D1 contains Darren, Dave, Sid & Bill then the formula:

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