=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)