Returning a value using multiple criteria

[RobNSB]

Hi All

I need help with the below table if you can please:

I am trying to return a value listed in the table by entering the following:

Eaves Height - 3-6
Cladding Type - Single Skin or Composite
Gable Width - 3-25

Eaves m> 3 3 4 4 5 5 6 6 Gable m SingleSkin Composite SingleSkin Composite SingleSkin Composite SingleSkin Composite 3 1100 1300 1200 1400 1300 1500 1400 1600 4 1100 1300 1200 1400 1300 1500 1400 1600 5 1100 1300 1200 1400 1300 1500 1400 1600 6 1100 1300 1200 1400 1300 1500 1400 1600 7 1100 1300 1200 1400 1300 1500 1400 1600 8 1100 1300 1200 1400 1300 1500 1400 1600 9 1100 1300 1200 1400 1300 1500 1400 1600 10 1100 1300 1200 1400 1300 1500 1400 1600 11 1300 1500 1400 1600 1500 1700 1600 1800 12 1300 1500 1400 1600 1500 1700 1600 1800 13 1300 1500 1400 1600 1500 1700 1600 1800 14 1300 1500 1400 1600 1500 1700 1600 1800 15 1300 1500 1400 1600 1500 1700 1600 1800 16 1500 1700 1600 1800 1700 1900 1600 2000 17 1500 1700 1600 1800 1700 1900 1600 2000 18 1500 1700 1600 1800 1700 1900 1600 2000 19 1500 1700 1600 1800 1700 1900 1600 2000 20 1500 1700 1600 1800 1700 1900 1600 2000 21 1700 1900 1800 2000 1900 2100 1800 2200 22 1700 1900 1800 2000 1900 2100 1800 2200 23 1700 1900 1800 2000 1900 2100 1800 2200 24 1700 1900 1800 2000 1900 2100 1800 2200 25 1700 1900 1800 2000 1900 2100 1800 2200 Eaves 6 Span 10 Cladding Composite Cost Per Bay #VALUE! <colgroup><col width="104" span="9" style="width:78pt"> </colgroup><tbody> </tbody>

<tbody>
</tbody>

Any help would be gratefully received

Thank you

 

[Fluff]

Hi & welcome to MrExcel
How about

Book1
	A	B	C	D	E	F	G	H	I
1	Eaves m>	3	3	4	4	5	5	6	6
2	Gable m	SingleSkin	Composite	SingleSkin	Composite	SingleSkin	Composite	SingleSkin	Composite
3	3	1100	1300	1200	1400	1300	1500	1400	1600
4	4	1100	1300	1200	1400	1300	1500	1400	1600
5	5	1100	1300	1200	1400	1300	1500	1400	1600
6	6	1100	1300	1200	1400	1300	1500	1400	1600
7	7	1100	1300	1200	1400	1300	1500	1400	1600
8	8	1100	1300	1200	1400	1300	1500	1400	1600
9	9	1100	1300	1200	1400	1300	1500	1400	1600
10	10	1100	1300	1200	1400	1300	1500	1400	1600
11	11	1300	1500	1400	1600	1500	1700	1600	1800
12	12	1300	1500	1400	1600	1500	1700	1600	1800
13	13	1300	1500	1400	1600	1500	1700	1600	1800
14	14	1300	1500	1400	1600	1500	1700	1600	1800
15	15	1300	1500	1400	1600	1500	1700	1600	1800
16	16	1500	1700	1600	1800	1700	1900	1600	2000
17	17	1500	1700	1600	1800	1700	1900	1600	2000
18	18	1500	1700	1600	1800	1700	1900	1600	2000
19	19	1500	1700	1600	1800	1700	1900	1600	2000
20	20	1500	1700	1600	1800	1700	1900	1600	2000
21	21	1700	1900	1800	2000	1900	2100	1800	2200
22	22	1700	1900	1800	2000	1900	2100	1800	2200
23	23	1700	1900	1800	2000	1900	2100	1800	2200
24	24	1700	1900	1800	2000	1900	2100	1800	2200
25	25	1700	1900	1800	2000	1900	2100	1800	2200
26
27	Eaves	3
28	Span	25
29	Cladding	Composite
30
31
32
33
34	Cost Per Bay	1900
Summary

Cell Formulas
Range	Formula
B34	=SUMPRODUCT((A3:A25=B28)*(B1:I1=B27)*(B2:I2=B29),B3:I25)

 

[steve the fish]

Hi. There will be a few ways to do this. Heres one:

=INDEX($B$3:$I$25,MATCH(B28,$A$3:$A$25,0),MATCH(1,INDEX(($B$1:$I$1=B27)*($B$2:$I$2=B29),0),0))

 

[RobNSB]

Thank you Fluff, that is fantastic.

 

[Fluff]

You're welcome & thanks for the feedback