ALADIN GAVE ME THIS TO USE YESTERDAY TO MAKE ALL #N/A's IN A SPREADSHEET 0.
=IF(ISNA(SETV(VLOOKUP(...))),0,VLOOKUP(...))
I am not sure what to put where the ... are. Ususally my VLOOKUP looks like =VLOOKUP(B2,A1:D1,2,FALSE)
Am I doing (VLOOKUP("N/A",a1:d1,?,false)????
=IF(ISNA(SETV(VLOOKUP(...))),0,VLOOKUP(...))
I am not sure what to put where the ... are. Ususally my VLOOKUP looks like =VLOOKUP(B2,A1:D1,2,FALSE)
Am I doing (VLOOKUP("N/A",a1:d1,?,false)????