if($B$2="",""VLOOKUP($B$2,'Supplier List'!$A$3:$F$7,2))
P Peo Sjoblom Aug 6, 2005 #2 if($B$2="","",VLOOKUP($B$2,'Supplier List'!$A$3:$F$7,2)) -- Regards, Peo Sjoblom (No private emails please)
if($B$2="","",VLOOKUP($B$2,'Supplier List'!$A$3:$F$7,2)) -- Regards, Peo Sjoblom (No private emails please)
K KL Aug 6, 2005 #3 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
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
J JV Aug 6, 2005 #4 That solved our problem. Thanks JV KL said: 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 Click to expand...
That solved our problem. Thanks JV KL said: 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 Click to expand...
