Your formula has *unequal* range sizes!

Make them *all* the same size:

=INDEX(Table!E1:E10,MATCH(1,(Table!A1:A10=E7)*(Tab le!B1:B10=F7)*(Table!C1:C1
0=G7)*(Table!D1:D10=H7),0))

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"kieffer" wrote in
message ...

I want to have a formula examine the contents in column A,B,C,D and if
satisified, it will return what is in column E



Table In Tab Named "Info"
A B C D E
Poly PU5 Gentex Comfort NTM
Triv PU5 Sola Max Class

In another tab, if someone inputs Poly, PU5, Gentex and Comfort, the
cell with a formula in it will return NTM.

The earlier post suggested using the Index formula followed with
Ctr-Sht-Ent to force an array....however, the formula is giving me an
error.


--
kieffer
------------------------------------------------------------------------
kieffer's Profile:
http://www.excelforum.com/member.php...o&userid=30848
View this thread: http://www.excelforum.com/showthread...hreadid=551671