If I don't have anything in the referenced cell noted in the formula
below it returns n/a. How do I get it to return something else? Example
(nothing)

(VLOOKUP(Quote!C21,'Data Base'!:A1:Z5000,6,FALSE)


--
MrSales
------------------------------------------------------------------------
MrSales's Profile: http://www.excelforum.com/member.php...o&userid=32572
View this thread: http://www.excelforum.com/showthread...hreadid=527769