Besides entering it as an array entered forumla (cntl-shift-enter) which
someone already mentioned, I believe you also want to adjust the range that
index is referring to. As I read it now, it is using all of column L
(meaning it would start on row 1), but the match you are performing starts in
row2. Why not make the range comparable to what you are looking up, ie,
L2:L3000
--
Kevin Vaughn


" wrote:

Ok Bob, based on the article you posted here's what I tried.

=INDEX('5-8 ICAS'!L:L,MATCH(A2&D2&R2,'5-8 ICAS'!$A$2:$A$3000&'5-8
ICAS'!$E$2:$E$3000&'5-8 ICAS'!$R$2:$R$3000,0))
I'm getting the "#N/A" error message on that formula. Can you see
anything that needs changed?

Thanks.