View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default 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.