Lookup Formula

[sciartilli]

Hello,

I am looking for a multi-lookup formula, based where two criteria need to be met.

I attached the file I am working on:

On sheet 2, cell L3 I am looking for a formula that will look up the values of B3 & L2 on SHEET 1 and give me the vaule of N2 on sheet 1.

[GeneralDisarray]

Hello,
On sheet 2, cell L3 I am looking for a formula that will look up the values of B3 & L2 on SHEET 1 and give me the vaule of N2 on sheet 1.

I don't see anything on your Sheet2 - what does B3 or L2 hold? (also, did you mean M2 and not N2).

[GeneralDisarray]

I think this might be what you want.

=SUMPRODUCT((Sheet1!$B$2:$B$122=Sheet2!B3)*(Sheet1!$L$2:$L$122=Sheet2!L2)*(Sheet1!$M$2:$M$122))