Vlookup, multiple results (in different cells)?

[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!

 

[Peo Sjoblom]

There is an example here

http://www.nwexcelsolutions.com/advanced_function_page.htm


it's number 6