|
Posted to microsoft.public.excel.misc
|
|
|
Lookup Price based on two values
Check this site out
http://www.excel-examples.com/excel-...sumproduct.htm
"tomhelle" wrote:
Have a data table on sheet 2 as follows:
Material 1 Thickness 1 Price 1
Material 1 Thickness 2 Price 2
Material 2 Thickness 1 Price 3
On sheet 1, I will specify the desired Material and Thickness but need a
formula to lookup the associated price.
Example: If I specify Material 1 and Thickness 2, I want a result of Price 2.
Many thanks in advance.
|