software

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: www.excelforum.com/member.php...oamp;userid=32572
View this thread: www.excelforum.com/showthread...hreadid=527769
if you add an extra bit to your formula it will work grand......

=if(isna(VLOOKUP(Quote!C21,'Data
Base'!:A1:Z5000,6,FALSE)),quot;quot;,VLOOKUP(Quote!C21,'Da ta
Base'!:A1:Z5000,6,FALSE))

Mark--
lister_d_000169
------------------------------------------------------------------------
lister_d_000169's Profile: www.excelforum.com/member.php...oamp;userid=32950
View this thread: www.excelforum.com/showthread...hreadid=527769=IF(Quote!C21=quot;quot;,quot;quot;,IF(ISNUMBER(MATCH(Quote!C21,'D ata
Base'!$A$1:$A$5000,0)),VLOOKUP(Quote!C21,'Data Base'!$A$1:$Z$5000,6,0),quot;quot;))

If 'Data Base'!$A$1:$Z$5000 is sorted in ascending order on column A...

=IF(Quote!C21=quot;quot;,quot;quot;,IF(LOOKUP(Quote!C21,'Data
Base'!$A$1:$A$5000)=Quote!C21,LOOKUP(Quote!C21,'Da ta
Base'!$A$1:$F$5000),quot;quot;))MrSales wrote:
gt; If I don't have anything in the referenced cell noted in the formula
gt; below it returns n/a. How do I get it to return something else? Example
gt; (nothing)
gt;
gt; (VLOOKUP(Quote!C21,'Data Base'!:A1:Z5000,6,FALSE)
gt;
gt;