IFERROR function

[Newbie20]

Hi All,

I am trying to add the IFERROR function to the following formula. I keep getting the #NA error message, but would like the cell to remain blank until values are input into columns H and I.

=(INDEX(Risks,MATCH($H14,'Dropdown list'!$H$4:$H$6,0),MATCH($I14,'Dropdown list'!$I$3:$L$3,0)))

Thanks in Advance.

 

[mrshl9898]

=IFERROR( (INDEX(Risks,MATCH($H14,'Dropdown list'!$H$4:$H$6,0),MATCH($I14,'Dropdown list'!$I$3:$L$3,0))) ,"")

or without your excess brackets =IFERROR(INDEX(Risks,MATCH($H14,Debtors!$H$4:$H$6,0),MATCH($I14,Debtors!$I$3:$L$3,0)),"")

=IFERROR(yourformula,"")

 

[Newbie20]

Worked perfectly. Thanks for responding so quickly.