Using IF, AND + OR Functions

Hi,

I was hoping someone would be able to help me to use the IF function but also to incorporate both AND and OR for multiple different options within the formula.

The data I am using is (hopefully) attached, and I want to automate the output to a cell both based on size (kW) and flow temperature (C). The selection will only be one size and one temperature, but the output varies depending on both. I think I have got my head around using IF with AND as I managed to get it to function with just one line, but having multiple is blowing my mind a bit. I've somewhat out something together below but any help would be greatly appreciated!

IF(AND(D3=16,D8=35),14.04)
(AND(D3=16,D8=40),13.66)
(AND(D3=16,D8=45),13.29)
(AND(D3=16,D8=50),12.38)
(AND(D3=12,D8=35),11.52)
(AND(D3=12,D8=40),11.25)
(AND(D3=12,D8=45),10.96)
(AND(D3=12,D8=50),10.42)
(AND(D3=8,D8=35),7.21)
(AND(D3=8,D8=40),6.98)
(AND(D3=8,D8=45),6.75)
(AND(D3=8,D8=50),6.36)

Hopefully added example workbook now?!

You could use the following formula in cell D9:

=IFERROR(INDEX($M$4:$P$12,MATCH(D3&"kW",$L$4:$L$12,0),MATCH(D8&"°C",$M$3:$P$3,0)),"no match")

However, this will only return data from the top 4 rows of the table, where appropriate, as it would not match with the lower rows.

Hope this helps.

Pete

Ive Managed to make it work however the results are spilling into adjacent cells?! index attempt.xlsx

Perfect! Thanks a lot!