LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default Help needed !! Look Up Table function ??

Can anyone tell me how to create a table or worksheet of information
comprising a grid of prices, I then want to be able to enter 2 values into a
form & have excel look-up the relevant price from the table.

Height of product along the Y axis, Width of product along the X axis, with
prices of the product for each variable.

100 150 200 250 (W)
100 50 51 52 53
150 55 56 57 58
200 60 61 62 63
250 65 66 67 68
(H)

EG, I want to be able to enter the Width & Height info into a form, say 150W
x 200H & excel returns the correct price, in this case £61.....
 
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
Calculation needed maybe a pivot table - Thank you Eduardo Excel Discussion (Misc queries) 2 November 5th 08 04:45 PM
Pivot Table Help Needed!!!! [email protected] Excel Discussion (Misc queries) 3 July 25th 08 01:52 PM
Pivot Table Assistance Needed Barb R. Excel Worksheet Functions 4 May 11th 05 05:11 PM
Pivot Table Assistance Needed Barb R. Excel Worksheet Functions 0 May 11th 05 02:51 PM
Pivot table subtotals help needed anthony Excel Discussion (Misc queries) 2 April 26th 05 12:47 PM


All times are GMT +1. The time now is 12:06 AM.

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

About Us

"It's about Microsoft Excel"