In the attachment you'll see a small example of what I'm looking at. In Column F I have =VLOOKUP(E2,C$2:D$1988,2,0) and this does exactly what I want. When ever it returns #N/A it means it didn't find a name match, but this means there is a position there instead, and I'd like that position returned into Column G.
I've fumbled for a bit but I can't get any one formula to work correctly. If something can be added to the first =VLOOKUP formula, great. If it has to be its own formula in Column G, that works too. Either option is fine since I'm just copying the data to another document as text only.
Bookmarks