ExcelBanter - Displaying what column a piece of data is in

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Displaying what column a piece of data is in (https://www.excelbanter.com/excel-worksheet-functions/160684-displaying-what-column-piece-data.html)

Ronin898

Displaying what column a piece of data is in

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

Darren Bartrup[_2_]

Displaying what column a piece of data is in

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

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

All times are GMT +1. The time now is 08:27 PM.