It looks good. The errors suggests that you didn't find any rows that match
all 3 criteria.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"epotter" wrote in
message ...


{=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)*(C7 4: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.


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