Say I have a list of names in column A on sheet1:
a1=joe
a2=jack
a3=ben
a4=lee
a5=alex
What formula would I have to enter in a cell on sheet2 of the same file to search columnA on sheet1 for the name "ben" and then return the row number?
I've have been trying now for a while and I can't get it. Any help would be very much appreciated.
Thanks in advance,
John
Bookmarks