Multipe Condition look-up

[spycein]

Dear All,

I have this following table

Item	Group	Amount
Rent-A-Cab	Operational	-
Office	Operational	80.00
TV	Bridal	-
Legal	Quality Assurance	100.00
Print	Traditional	100.00

<tbody>
</tbody>

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)