- Joined
- 30 June 2007
- Posts
- 7,200
- Reactions
- 1,225
No problem, GB
Here is the conditional version that gives you n/a if your search name is not in the list at all.
=IF(R1C3=VLOOKUP(R1C3,R1C1:R1000C2,1),VLOOKUP(R1C3,R1C1:R1000C2,2),NA())
The table in the leftmost columns must be sorted in ascending order. Of course, you can replace the 1000 by the row number of the last table entry.
(I prefer R1C1 notation)
Amazing.