Lookup 2 Columns Simultaneously

[gurpreet161]

Hello,

I would like help for doing a formula where I do lookup simultaneously from first 2 columns and then picking up the value from the third column. Please help!

4 1 1111.11
5 1 2222.22
6 1 4444.44
4 2 3333.33
5 2 8888.88
6 2 6666.66
4 3 7777.77
5 3 9999.99
6 3 5555.55


For example, I would like to lookup column 1 for value 6 and then against all the values of 6 in the first column, I would like to look for the value of 2. Wherever 2 occurs against 6, I want to pick up the value in the third column.

Please let me know how it works. Thank you all!

[rylo]

Hi

With your source data in the range A1:C9, 6 in F1 and 2 in G1 then try

=SUMPRODUCT(--(A1:A9=F1),--(B1:B9=G1),(C1:C9))


rylo