=VLOOKUP("lookup_value",Items!a2:B200,2,False)


--

HTH

RP
(remove nothere from the email address if mailing direct)


"JohnT" wrote in message
...
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!!!