Lookup Price based on two values

T

tomhelle

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.
 
T

T. Valko

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create summarized list from larger list 2
Create asummarized list from larger list 5
v look value dependant on 2 cells 4
formulas to match row in a table from given values 3
Removing an inch mark 2
Lookup from an array 3
IF and VLOOKUP formula 9
creating formula to return one of several values 4

Top