Index Match (with multiple matches across multiple columns)

[qrtback10]

Below is the formula that I'm currently using. When entered it returns error message: "Did not find value '1300' in MATCH evaluation". What am I doing wrong? The 'Bedrooms' column (S2) should equal "3 BD From". Please advise. Thank you!

=ARRAYFORMULA(INDEX(H1:L1,MATCH(1300,INDEX(H1:L,1),0),MATCH(R2,O2:O,0)))

0 BD From	1 BD From	2 BD From	3 BD From	4 BD From	Marker Type	Notes	Code	Rating		Code	Bedrooms	Rent
1332	1448	2652			ltblu_blank		CC-ALL-2929	CC		CC-GRE-1001		1300
1071	1259	1755			ltblu_blank		CC-ALL-2901	AA
831	1015	1308			ltblu_blank		CC-ALL-1991	DD
710	867	1200	1785		ltblu_blank		CC-COL-2222	AA
697	812	1064			buildings		CC-COL-1201	AA
	950	1159	1300		ltblu_blank		CC-GRE-1001	AA
1265	1463	2341			ltblu_blank		CC-GRE-800	BB
	679	823	972		ltblu_blank		CC-GRE-1900	BB

<tbody>
</tbody>

 

[Domenic]

Try...

=INDEX(H1:L1,MATCH(T2,INDEX(H2:L9,MATCH(R2,O2:O9,0),0),0))

Hope this helps!

 

[qrtback10]

Man, you guys are good! Thanks Domenic! That was exactly what I needed. Will save this and remember to nest INDEX within MATCH. Thanks!

 

[Domenic]

You're very welcome!