Hey guys, I am trying to make the "0%" (in the day over day change context) to show as N/A in the dashboard (in a different tab).
The data shows in a tab called Sheet 5, and is pulled to a tab called Dash.
This is under top 10 reasons so it needs to be one function for all 10 reasons (which differ daily)..
I tried =IFERROR(INDEX(Sheet5!$FJ$26:$FJ$105,MATCH(Dash!B42,Sheet5!$A$26:$A$105,0)),"N/A") but thats a no go.
Any suggestions? Thanks.
Bookmarks