Posted to microsoft.public.excel.misc

amik

external usenet poster

Posts: 15

pulling mulitple fields from a table through lookup

Some of the fields I want to pull from a table repeat themselves. When I run
the lookup to get the information I need it only pulls up the first one on my
table.

Name Store Id
Rob 12
Mary 13
Rob 14
John 15
Rob 16

Any ideas to display all three would be appreciated.

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
Mulitple value lookup	kritter286	Excel Worksheet Functions	5	April 20th 09 10:16 PM
Matrix lookup/mulitple criteria lookup	MarkFranklin	Excel Discussion (Misc queries)	3	March 31st 08 10:15 AM
Lookup mulitple tabs	jillteresa	Excel Worksheet Functions	5	July 17th 06 09:37 PM
LookUp with Mulitple Criteria	TimR	Excel Discussion (Misc queries)	4	July 13th 06 12:22 AM
Pulling date from 1 ws to another while referencing 2 fields	Hakojin	Excel Discussion (Misc queries)	4	May 19th 06 10:20 PM

All times are GMT +1. The time now is 07:10 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us