View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
klh84 klh84 is offline
external usenet poster
 
Posts: 6
Default Vlookup multiple items under one ID

Is there a way to use one function to lookup two values under the same unique
ID.

EX:
Account Value
55 20
55 50

I was hoping to find a way to write a vlookup for this that would pull in
the 20, and then also be able to pull in the 50 as well in the same function.
Is this possible?