I guess I'm a bit thick because I am just not getting it after looking at
help and searching the forum here...
I have a separate worksheet that has 2 columns, an item number and a
description. I would like to NOT have to enter the description each time in
separate worksheets so I thought VLOOKUP would be the way to go.
I have accounts in different tabs (worksheets) in a workbook and have
created a tab (worksheet) with the item number and description only: Items is
the name of the worksheet and columns A2 to A200 have the number and B2 to
B200 the corresponding description.
Something I'm doing is wrong because this isn't working:
VLOOKUP(Items!a2:a200,Description,False)
Could someone please help out?
Thanks in advance!!!