View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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!