I need to insert a description using if and vlookup
worksheet call tax invoice, in cell a5 is a catalogue No.

in cell b5 I need to insert the description of that Catalogue number which
is in a named range in a worksheet called "product"

This is the formula i come up with but it does not work
=if(a5" ",vlookup(a5,product,2,false)," ")

Mate,

You might have more takers in an Excel newsgroup. AFAIK, Word doesn't
use worksheets.

Try this:
=IF(A5" ",VLOOKUP(A5,Sheet2!A2:H14,2,FALSE)," ")

Change the cell references to be what you need.


"yourmate" wrote in message
news
I need to insert a description using if and vlookup
worksheet call tax invoice, in cell a5 is a catalogue No.

in cell b5 I need to insert the description of that Catalogue number which
is in a named range in a worksheet called "product"

This is the formula i come up with but it does not work
=if(a5" ",vlookup(a5,product,2,false)," ")