Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I pull complete records from a table using an outside valu
I have an Excel table that lists over 500 boxes by product number,
description, usable space, and price. Is it possible to use calculated data from another sheet to look up and provide the box products that match the calculated usable space and display a list of the matching products with complete field information? Here's an example of the data on one sheet: Product # Description Usable Space Price ABC25 Kraft 6sx6x2 72 .012 ABD44 Kraft 6x6x4 144 .015 CRL36 Kraft 8x6x3 144 .018 The calculated usable space on the second worksheet might look something like this to allow a customer to enter the desired dimensions: A B C D 1 Length Width Depth Calculated Space 2 6 6 4 144 where the calculated space is determined by the formula =B1*B2*B3 The matching records would then be displayed below the calculation area, with all fields pertaining to each record. Thank you for any help you can provide. -- Gracie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What function should I use to pull those records that match | Excel Worksheet Functions | |||
Pivot table - There are too many records to complete this operatio | Excel Discussion (Misc queries) | |||
combining rows of data to make complete records | Excel Discussion (Misc queries) | |||
'too many records to complete operation'... | Excel Discussion (Misc queries) | |||
Too many records to complete this operation | Excel Discussion (Misc queries) |