return value other than #N/A
 

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?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200604/1

return value other than #N/A
 

This formula in some cell will give a blank cell if A1 has an error, and
will give what's in A1 if not. HTH Otto
=IF(ISERROR(A1),"",A1)

"mtbrindamour via OfficeKB.com" <u11944@uwe wrote in message
news:5e4b19e4700b2@uwe...
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?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200604/1

return value other than #N/A
 

=IF(ISNA(vlookupformula,"",vlookupformula))


Gord Dibben MS Excel MVP

On Tue, 04 Apr 2006 22:30:43 GMT, "mtbrindamour via OfficeKB.com" <u11944@uwe
wrote:

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?