How do you nest the following formula to show blank cells

[Guest]

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

 

[Peo Sjoblom]

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

--
Regards,

Peo Sjoblom

(No private emails please)

 

[KL]

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

 

[Guest]

That solved our problem.

Thanks
JV

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