Posted to microsoft.public.excel.worksheet.functions

Johan[_2_] Johan[_2_] is offline

external usenet poster

Posts: 11

Vlookup, multiple results (in different cells)?

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!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
adding multiple vlookup results	fomo	Excel Worksheet Functions	7	January 30th 07 08:43 PM
how to return multiple results in vlookup?	Landa	Excel Worksheet Functions	3	July 20th 06 08:27 AM
Vlookup on multiple cells	Debbie	Excel Worksheet Functions	15	June 29th 06 09:00 PM
Add multiple vlookup results	Dawn	Excel Worksheet Functions	6	June 20th 06 10:06 PM
VLOOKUP - Multiple cells in lookup value	RMF	Excel Worksheet Functions	1	January 23rd 06 10:28 AM

All times are GMT +1. The time now is 03:51 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us