Multiple IFERROR(Index(Match

[Kmitchell]

Good Morning,

The below calculation works except when it hits if($D293 ="PCP"... its returning $0 and it should return a value. Does it have something to do with my parenthesis placement? It works if $D293 = "SPEC"

=IFERROR(IFERROR(IFERROR(IF($D293="SPEC",INDEX('Community FS'!$F$5:$F$14281,MATCH($M293,'Community FS'!$R$5:$R$14281,0))),IF($D293="SPEC",INDEX('Community FS'!$F$5:$F$14281,MATCH($N293,'Community FS'!$S$5:$S$14281,0)))),IF($D293="PCP",INDEX('Community FS'!$H$5:$H$14281,MATCH($M293,'Community FS'!$R$5:$R$14281,0)))),IF($D293="PCP",INDEX('Community FS'!$H$5:$H$14281,MATCH($N293,'Community FS'!$S$5:$S$14281,0))))*K293

 

[Fluff]

Maybe

=IF($D293="SPEC",
    IFERROR(INDEX('Community fs'!$F$5:$F$14281,MATCH($M293,'Community fs'!$R$5:$R$14281,0)),INDEX('Community fs'!$F$5:$F$14281,MATCH($N293,'Community fs'!$S$5:$S$14281,0))),
IF($D293="PCP",
    IFERROR(INDEX('Community fs'!$H$5:$H$14281,MATCH($M293,'Community fs'!$R$5:$R$14281,0)),INDEX('Community fs'!$H$5:$H$14281,MATCH($N293,'Community fs'!$S$5:$S$14281,0)))))*K293

 

[mole999]

cant decide why i think this is wrong
=IFERROR

(IFERROR

(IFERROR

(IF($D293="SPEC",INDEX('Community FS'!$F$5:$F$14281,MATCH($M293,'Community FS'!$R$5:$R$14281,0)))

,IF($D293="SPEC",INDEX('Community FS'!$F$5:$F$14281,MATCH($N293,'Community FS'!$S$5:$S$14281,0))))

,IF($D293="PCP",INDEX('Community FS'!$H$5:$H$14281,MATCH($M293,'Community FS'!$R$5:$R$14281,0))))

,IF($D293="PCP",INDEX('Community FS'!$H$5:$H$14281,MATCH($N293,'Community FS'!$S$5:$S$14281,0))))*K293

but you are only testing SPEC and PCP

 

[Kmitchell]

This worked perfectly! Thank you so much!

 

[Fluff]

Glad we could help & thanks for the feedback.