Providing that Column A contains unique values then I would recommend a
Vlookup Function. You can find it in the help.
--
HTH...

Jim Thomlinson


"s&d" wrote:

I was wondering if someone can gear me in the right direction with this.

I created a data-only worksheet with 2 columns as per below with all the
data: I called the worksheet "User Names"

in column A in column B

1 j. doe
2 k. anderson
3 l. wilson
4 m. robinson
5 n. woods

In a separate blank worksheet with the following headings, I would like to
retrieve the data from the "User Names" worksheet.

User Number User Name

For example: If I typed in the number "3" under "User Number" column, I
would like it to lookup the number "3" in the "User Names" worksheet and
retrieve the name "l. wilson" and insert it in the cell under "User Name".

Any information would be greatly appreciated, the whole purpose of this is
to save time from writing out the User names all the time.

Thanks,
Sherry.