VLOOKUP(A4,'4PM_JAN16 MTD'!$A$3:$AC$101,29,FALSE)
I'm getting some #N/A values when N/A is not in the $A$3:$AC$101 range. How do I modify the formula so it just shows a blank, instead of #N/A, if A4 does not appear in the range that I'm trying to return a value from?
I'm getting some #N/A values when N/A is not in the $A$3:$AC$101 range. How do I modify the formula so it just shows a blank, instead of #N/A, if A4 does not appear in the range that I'm trying to return a value from?