Posted to microsoft.public.excel.misc

pellepannekake pellepannekake is offline

external usenet poster

Posts: 1

Lookup problem want 2 or more results

Hi, I have this list;
customer id invoice no.
300100 123
300100 456
300200 654

My question is; which invoices do customer 300100 have?
I want answer; no. 123 and 456.
How can I use Lookup to give me this result?

--
Best regards Pellepannekake

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
How do I get correct results when LOOKUP with calculated numbers	onthemountain	Excel Worksheet Functions	2	July 20th 06 01:13 AM
multi sheet lookup with multiple results	Alec H	Excel Discussion (Misc queries)	1	March 10th 06 08:05 PM
Odd problem with LOOKUP	no-sweat	Excel Discussion (Misc queries)	2	September 1st 05 06:46 PM
LOOKUP problem!!!	G	Excel Worksheet Functions	1	August 20th 05 12:02 AM
Lookup Function Problem	seve	Excel Discussion (Misc queries)	9	February 28th 05 02:46 AM

All times are GMT +1. The time now is 05:52 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us