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

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

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

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