Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculation needed maybe a pivot table - Thank you | Excel Discussion (Misc queries) | |||
Pivot Table Help Needed!!!! | Excel Discussion (Misc queries) | |||
Pivot Table Assistance Needed | Excel Worksheet Functions | |||
Pivot Table Assistance Needed | Excel Worksheet Functions | |||
Pivot table subtotals help needed | Excel Discussion (Misc queries) |