Thanks very much. I found that I hadn't selected the correct range too and
your bit of help got me over the hump!
Thanks again!

"CoRrRan" wrote:

You are using the VLOOKUP-function incorrectly:

It should be something like this:
=Vlookup
(ToBeLookedUpValue,RangeContainingValue,ColumnOfRa ngeContainingToBeFoundI
tem,False)

Which would be something like:
Range A1 contains value 100
Range A2 to A200 in worksheet "Items" contain numbers from 1 to 199 by
example), including "100".
Range B2 to B200 in worksheet "Items" contain the descriptions for items
1 to 199

To get the description for value "100", do this:

=Vlookup(A1,Items!A2:A200,2,False)

HTH,
CoRrRan

"?B?Sm9oblQ=?=" wrote in
:

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!!!