I have a range of 125 rows, 4 columns, where the 1st column is member# and the 2nd is lastname. It's in sort order on member#. I want to be able to find the row number (not the member#) of a specific lastname. 'Twould be easy if the range were sorted on lastname - I'd use vlookup. Any clues?
I'm new to the forum, but been using Excel (self-taught) for over 20 years.
Could someone tell me where to go? (Be nice )
Bookmarks