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

--
Regards,

Peo Sjoblom

(No private emails please)


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