If and Vlookup

[Guest]

I would like to know a formula using the if and vlookup formulas how to
insert a description of an item from another work sheet
sheet, using a catologue number,

This is the best i could come up with

if(a5<>"",vlookup(a5,StockDetails,2,false),"")

can you tell me where i am going wrong?

 

[Jason Morin]

Your formula looks fine to me. What's happening?

HTH
Jason
Atlanta, GA

 

[JulieD]

Hi

is StockDetails a range name (insert / name / define ) that consists of at
least two columns, the one on the left being the catelog number and the one
on the right being the description?

if it is, then your formula should work ... what problems are you
encountering?

Cheers
JulieD