lookup value from table

[AnnetteTR]

Hi
I have two values I shall use to find a third value from a table.
The table look like this:

Excel Workbook
	A	B	C	D
1		Very low polluting	Low polluting	Non low polluting
2		m/h/m2	m/h/m2	m/h/m2
3	Cat A	1,80	3,60	7,20
4	Cat B	1,26	2,52	5,04
5	Cat C	1,08	1,44	2,88
Sheet1

Eg. I want to look up the value for Cat B at Low polluting then I shall use the value in row 4 column C
But how do I put that into a formula?

Regards Annette

 

[njimack]

Assuming F1=Cat B and F2=Low polluting,
=INDEX(B3:D5,MATCH(F1,A3:A5,0),MATCH(F2,B1:D1,0))

 

[VoG]

Try

=INDEX(A1:D5,MATCH(A4,A1:A5,0),MATCH(C1,A1:D1,0))

 

[AnnetteTR]

Hi Neil and Peter

Thankyou for your quick responses - now I it works.

Regards Annette