I have a formula - =(INDEX(EO$4:EO$9,MATCH('Roll Data'!$H13,$EK$4:$EK$9,0))) which reference data from Sheet 'Roll Data'. If no data is available the cell will show #N/A. Is there a way to change/add to the formula to test the reference data and if there is no data then just leave the blank and not #N/A.
Bookmarks