M
mtbrindamour via OfficeKB.com
I have a spreadsheet utilizing a VLOOKUP- VLOOKUP(A1,Tariff,4,false). Upon
the false lookup, the formula returns #N/A, and a true lookup returns a
dollar amount. In the next column, I want to put a value based on the
VLOOKUP return, and if it is #N/A to put a blank. I cannot seem to get any
valuse returned in the second column other than #N/A if a false lookup occurs.
Does anyone know how I do this?
the false lookup, the formula returns #N/A, and a true lookup returns a
dollar amount. In the next column, I want to put a value based on the
VLOOKUP return, and if it is #N/A to put a blank. I cannot seem to get any
valuse returned in the second column other than #N/A if a false lookup occurs.
Does anyone know how I do this?