Lookup based on two conditions
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.
|