View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
grayfilly grayfilly is offline
external usenet poster
 
Posts: 3
Default 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