Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a table containing prices of a product with the width across the
columns and length down the rows looking something like this; 25 30 35 40 25 4.60 5.20 6.35 7.10 30 5.15 6.20 7.85 8.30 35 6.15 7.50 8.30 9.20 What I am looking for is for the user to enter values in 2 cells (width and length), and have the price returned for the product in the price cell. eg; if the user enters width 32 and length 26 it would return 7.85 in the price cell (it must always round up not down) I hope you understand what I want. Thanks in anticipation. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count Distinct Values by Group Using Pivot Table (NM) | Excel Worksheet Functions | |||
Pivot Table with Zero Values for Month | Charts and Charting in Excel | |||
table | Excel Worksheet Functions | |||
how can i fill a table with values from repeated regressions | Excel Worksheet Functions | |||
Sum minimum values in a pivot table | Excel Worksheet Functions |