How do you nest the following formula to show blank cells
 

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

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

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

That solved our problem.

Thanks
JV
"KL" wrote:

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