Lookup Price based on two values
 

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.

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.

Lookup Price based on two values
 

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.


Take a look at
http://xldynamic.com/source/xld.SUMPRODUCT.html

Lookup Price based on two values
 

Try this...

Sheet1:

A1 = Material 1
B1 = Thickness 2

Table on Sheet2 in the range A1:C3

=SUMPRODUCT(--(Sheet2!A1:A3=A1),--(Sheet2!B1:B3=B1),Sheet2!C1:C3)


--
Biff
Microsoft Excel MVP


"tomhelle" wrote in message
...
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.