Vlookup, multiple results (in different cells)?

  • Thread starter Thread starter Johan
  • Start date Start date
J

Johan

I have searched the newsgroups for "vlookup multiple results" but I
haven't seen the solution for this problem.

I have a table like this

AA 2
BB 3
AA 4
BB 5
AA 6
AA 7
CC 8

I would like to use two (or more) VLOOKUP functions in different
cells, one to find the first "AA" value (2) and one to find the second
"AA" value ("3") and so on.

How do I do this?

Thanks!
 
Back
Top