One way...

E1 = 1
F1 = 3

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

This will only work if the value to be returned in a number.

This array formula** will work with any data type:

=INDEX(C1:C4,MATCH(1,(A1:A4=E1)*(B1:B4=F1),0))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

--
Biff
Microsoft Excel MVP


"Ash" (donotspam) wrote in message
...
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 :)