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?

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

HTH
Jason
Atlanta, GA

-----Original Message-----
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?


.

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

"yourmate" wrote in message
...
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?