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