Lookup within a Lookup

[carl-barratt]

I have a speadsheet that needs to look at two cells then make them match up and return a result. Very similar to a standard lookup but by adding an additional cell to match before returning the reuslt.

Must match a and b then look at a speadsheet and match them up and return a result in that cell.

Thanks for your help

Carl

 

[barry houdini]

Possibly this sort of array formula

=INDEX($C$1:$C$10,MATCH(1,($A$1:$A$10=D1)*($B$1:$B$10=E1),0))

confirmed with CTRL+SHIFT+ENTER

where you are looking for the value in column C where column A matches D1 and column B matches E1