Hi JV,

just like you have, but adding a comma:

=IF($B$2="","",VLOOKUP($B$2,'Supplier List'!$A$3:$F$7,2))

Regards,
KL


"JV" wrote in message
...
if($B$2="",""VLOOKUP($B$2,'Supplier List'!$A$3:$F$7,2))