If and Vlookup

Y

yourmate

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?
 
J

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
 
Top