{=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=E1 1),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.


--
epotter
------------------------------------------------------------------------
epotter's Profile: http://www.excelforum.com/member.php...o&userid=36063
View this thread: http://www.excelforum.com/showthread...hreadid=558532