Currently my client designed a spreadsheet with a VLOOKUP formula throughout the form. Every cell that has that formula applied to it shows “#N/A” until data is entered. Is there a way to hide the #N/A in the cells without taking away the formulas? Here is the current formula in the cells: =VLOOKUP(A14,DATA_EQUIP,2,FALSE)
Would like to print when needed & the N/A doesnt look so great. The only way I was able to hide the N/A’s the formulas disappeared.
