N/A return
 

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

N/A return
 

if you add an extra bit to your formula it will work grand......

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

Mark


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

N/A return
 

=IF(Quote!C21="","",IF(ISNUMBER(MATCH(Quote!C21,'D ata
Base'!$A$1:$A$5000,0)),VLOOKUP(Quote!C21,'Data Base'!$A$1:$Z$5000,6,0),""))

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

=IF(Quote!C21="","",IF(LOOKUP(Quote!C21,'Data
Base'!$A$1:$A$5000)=Quote!C21,LOOKUP(Quote!C21,'Da ta
Base'!$A$1:$F$5000),""))


MrSales wrote:
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)