K
Koomba
I neglected to include my formula in the 1st message. Sorry. Here it is:
=VLOOKUP(B4,'Price List'!$A$3:$B$13,2,FALSE)
=VLOOKUP(B4,'Price List'!$A$3:$B$13,2,FALSE)
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
=if(b4="","",VLOOKUP(B4,'Price List'!$A$3:$B$13,2,FALSE))
K
Koomba
Dave: that was SIMPLY great. Thanks
S
ShaneDevenshire
Hi,
Since you didn't include the first message I'm not sure this will help:
=IF(B4,VLOOKUP(B4,'Price List'!$A$3:$B$13,2,0),"")
Note - if you name the range in the sheet called Price List, for example PL,
then your formula no longer needs a sheet reference, and since range names
are absolute by default you don't need the $ signs. So your formula can
simplify to:
=IF(B4,VLOOKUP(B4,PL,2,0),"")
Since you didn't include the first message I'm not sure this will help:
=IF(B4,VLOOKUP(B4,'Price List'!$A$3:$B$13,2,0),"")
Note - if you name the range in the sheet called Price List, for example PL,
then your formula no longer needs a sheet reference, and since range names
are absolute by default you don't need the $ signs. So your formula can
simplify to:
=IF(B4,VLOOKUP(B4,PL,2,0),"")
F
franciz
another basic alternative would be
=IF(ISNA(VLOOKUP(B4,'Price List'!$A$3:$B$13,2,FALSE)),"",VLOOKUP(B4,'Price
List'!$A$3:$B$13,2,FALSE))
you can have not found by replacing "" with "not found" in the formula.
regards,
=IF(ISNA(VLOOKUP(B4,'Price List'!$A$3:$B$13,2,FALSE)),"",VLOOKUP(B4,'Price
List'!$A$3:$B$13,2,FALSE))
you can have not found by replacing "" with "not found" in the formula.
regards,