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.
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.