Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 49

vlookup - more than one result

Hello everybody,

Does anybody know if it is possible to create a lookup formula, which
returns all values if more than one?

For instance:

1 Tom
1 Dick
1 Harry

Then I want it to return all three names when looking up 1.

Best regards
Heine

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
Show result of a SUM in a VLOOKUP	Sarah (OGI)	Excel Worksheet Functions	5	March 23rd 07 05:50 PM
Vlookup result change	DP7	Excel Worksheet Functions	1	March 6th 07 04:28 PM
vlookup shows result one cell above the expected result	Marie	Excel Worksheet Functions	7	November 14th 06 02:52 AM
VLOOKUP - Can't see result	plunk25	Excel Worksheet Functions	1	June 29th 06 04:58 PM
vlookup based on random result returns incorrect result	rickat	Excel Worksheet Functions	1	December 6th 05 01:16 PM

All times are GMT +1. The time now is 03:15 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us