multiple index(match with ISERROR

[Kmitchell]

Hello,

I have a multiple index(match that works but I would like to add an IF(ERROR on the first condition so that I can eliminate the #NAs .

INDEX('HOA-HOS'!$E$8:$E$12508,MATCH('3.Claim Line Detail O vs F'!$S4,'HOA-HOS'!$B$8:$B$12508,0))*INDEX('FS INFLATORS'!$D$2:$D$3,MATCH('3.Claim Line Detail O vs F'!$G4,'FS INFLATORS'!$C$2:$C$3,0))

If the first index(match is not found on HOA/HOS then "Not on Fee schedule", otherwise give me the rate identified. Part 2 of the index(match is the multiplier.

Please advise.

Thanks kindly!

 

[Aladin Akyurek]

Something like:

=IF(ISNUMBER(MATCH('3.Claim Line Detail O vs F'!$S4,'HOA-HOS'!$B$8:$B$12508,0)),INDEX('HOA-HOS'!$E$8:$E$12508,MATCH('3.Claim Line Detail O vs F'!$S4,'HOA-HOS'!$B$8:$B$12508,0))*INDEX('FS INFLATORS'!$D$2:$D$3,MATCH('3.Claim Line Detail O vs F'!$G4,'FS INFLATORS'!$C$2:$C$3,0)),"Not on Fee schedule")