Posted to microsoft.public.excel.worksheet.functions
|
|
Vlookup, multiple results (in different cells)?
There is an example here
http://www.nwexcelsolutions.com/adva...ction_page.htm
it's number 6
--
Regards,
Peo Sjoblom
"Johan" wrote in message
oups.com...
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!
|