Thread: Sum Product Matrix
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Phycodes Phycodes is offline
external usenet poster
  
Posts: 2
Default Sum Product Matrix
I have also tried:

{=INDEX($A:$E,MATCH(1,(A:A=K9)*(IF('SalaryInput'D 2,E2,IF('SalaryInput'C2,D2,IF('SalaryInput'B2,C2 ,B2)))),0),4)}

but get an #N/A error
Reply With QuoteReply With Quote