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 |
Formula correction
Oops. Formula should read =A2*B2*C2
-- Gracie "grayfilly" wrote: 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 |
How can I pull complete records from a table using an outside valu
A standard lookup table will do this for you as long as both tables have a
unique reference for each product. Mick "grayfilly" wrote in message ... 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 |
How can I pull complete records from a table using an outside
Thanks, Mick. At least I know I'm on the right track. I'm self-taught in
Excel and know enough beyond the basics to give myself problems. So now it's back to the books to learn more about lookup tables. If you have the time and are willing to, could you give me an example of how this process might be done? Meanwhile, I will get back to my references and see what I can do on my own. -- Gracie "Mick Wildman" wrote: A standard lookup table will do this for you as long as both tables have a unique reference for each product. Mick "grayfilly" wrote in message ... 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 |
All times are GMT +1. The time now is 01:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com