Multipe Condition look-up

[spycein]

Dear All,

I have this following table

[TABLE="class: grid, width: 261, align: left"]
<tbody>[TR]
[TD="align: center"]Item[/TD]
[TD="align: center"]Group[/TD]
[TD="align: center"] Amount[/TD]
[/TR]
[TR]
[TD="align: center"]Rent-A-Cab[/TD]
[TD="align: center"]Operational[/TD]
[TD="align: center"] -[/TD]
[/TR]
[TR]
[TD="align: center"]Office[/TD]
[TD="align: center"]Operational[/TD]
[TD="align: center"] 80.00[/TD]
[/TR]
[TR]
[TD="align: center"]TV[/TD]
[TD="align: center"]Bridal[/TD]
[TD="align: center"] -[/TD]
[/TR]
[TR]
[TD="align: center"]Legal[/TD]
[TD="align: center"]Quality Assurance[/TD]
[TD="align: center"] 100.00[/TD]
[/TR]
[TR]
[TD="align: center"]Print[/TD]
[TD="align: center"]Traditional[/TD]
[TD="align: center"] 100.00[/TD]
[/TR]
</tbody>[/TABLE]










I want a formula which will the Amount Column value to Cell "C1" when i enter any value from Item Column in cell "A1" & "B1".

For example
if i put Rent-A-Cab in cell A1 & Operational in B1 then the return value should be 0.
if i put Office in cell A1 & Operational in B1 then the return value should be 80.

Thanks

 

[Oaktree]

With your lookup table in cells G1:I6, use this formula in cell C1: =LOOKUP(2,1/((G2:G6=A1)*(H2:H6=B1)),I2:I6)