I want to return a value in column E when column A,B,C and D are
satisfied. I'm getting an error with the formula below

=INDEX(Table!E1:E10,MATCH(1,(Table!A5:A10=E7)*(Tab le!B5:B10=F7)*(Table!C5:C10=G7)*(Table!D1:D10=H7), 0))


A B C D E
Poly PU5 Sola Max NTMc
Poly PU5 Gentex Natural NTMc
607 PC8 Essilor Natural Classic
Poly PU2 Gentex Blue Classic
*table is located in a tab labeled "Table"


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