How can I retreive multiple records using a lookup?
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.
|