Hi,

This will work provided the combination is unique. But if it is not you
will need to tell us what you want, that is if there are two items that match
the criteria:

=SUMPRODUCT((A1:A4=E1)*(B1:B4=F1)*C1:C4)

Where E1 contains the first item you want to look up and F1 the second.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Ash" wrote:

I am trying to create a lookup formula that looks up a value in one column
and then looks up a second value in the second column and returns the value
in the third column corresponding to the two values.

Eg,

1 3 45
1 4 56
2 2 34
2 5 67

Look up 1 in column 1 then 3 in column 2 and return 45

Please help
--
Ash :)