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" <epotter.2ahnqp_1152130204.7405@excelforum-nospam.com> wrote in
message news:epotter.2ahnqp_1152130204.7405@excelforum-nospam.com...
>
>
{=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.
>
>
> --
> epotter
> ------------------------------------------------------------------------
> epotter's Profile:
http://www.excelforum.com/member.php...o&userid=36063
> View this thread: http://www.excelforum.com/showthread...hreadid=558532
>