How can I retreive multiple records using a lookup?

jrpey · #1 11-11-2011, 07:30 AM

I have a workbook that contains 2 worksheets that contain the raw data the user will be working with. This data changes daily so I cannot use a filter. I need to look up the Run Number listed within the RawData sheet on the Table sheet and then bring over the Quantity Detail. There can be more than one instance of the Run Number to reflect the different quantity details. I need to bring each instance over horizontally. I am attaching the spreadsheet.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Deleting records/results from mail merge	alexb123	Mail Merge	2	08-12-2011 02:27 PM
Merge Doc skips records	eonelson	Excel	11	01-30-2011 03:49 PM
Mail Merge - Many Records for Each Addressee	awalker1970	Mail Merge	1	12-31-2010 11:52 AM
Combine Records when Mail Merge from Access	Tom Pickles	Misc	2	08-24-2010 06:00 PM
Help with consolidating multiple records into one	wbiggs2	Excel	0	11-30-2006 01:02 PM