View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CHACHING CHACHING is offline
external usenet poster
 
Posts: 2
Default VLookup - Choose Which Occurence of Lookup value to bring back

I have a table where the lookup value appears multiple times .....

ie Table Looks like this

Value Ref
3 A
5 Z
6 B
7 C
3 F
5 G

With standard lookup functionality, If I looked-up value 3, I would bring
back "A"
I'd like a method where I can specify which occurence of "3" in the table it
brings back data from. (ie to be able to do a lookup & specify to bring back
data from the second record of "3" rather than the default first)

Any Ideas ????