LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What function should I use to pull those records that match Helen Excel Worksheet Functions 3 April 2nd 08 11:46 PM
Pivot table - There are too many records to complete this operatio Gerryboy Excel Discussion (Misc queries) 0 August 3rd 07 10:44 AM
combining rows of data to make complete records cjemerson8 Excel Discussion (Misc queries) 1 March 18th 06 06:38 PM
'too many records to complete operation'... jimmyp Excel Discussion (Misc queries) 1 March 7th 06 03:30 PM
Too many records to complete this operation Ed P Excel Discussion (Misc queries) 0 September 19th 05 11:28 PM


All times are GMT +1. The time now is 07:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"