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