{=IF(C12="Y",INDEX(A74:A112,MATCH(1,(B74:B112=E13)*(D74:D112<E12)*(E74:E112=E11),0)),INDEX(A74:A112,MATCH(1,(B74:B112=E13)*(C74:C112=E12)*(E74:E112=E11),0)))}


Getting a N/A value any ideas. C12 = Fire Rated check, E13 = height, E12 = Depth, E11 = Trim style.

I added (E74:E112=E11) to check for Trim style. I can assume we are looking for all true values of 1 to confirm the match(1,

Sorry but just learning excel.