Referencing different workbooks

[jimmy]

I have two seperate workbooks that both contain
information. One workbook contains a user key followed
with other relevent information. The other workbook
contains that user key alongside with the users real
name. I want to be able to retrieve the user name in the
workbook that only contains the user key and populate them
there. I would appreciate any help that you can offer.
Thanks a million!!!

 

[Ozzie]

you didn't give enough info to provide a formula, or an in-
depth answer. Taking a stab - you can use vlookup
function (use the formula wizard to help you set it up).

 

[cmoore]

The data in the spreadsheet containing the name should be sorted
alphabetically. Select the data and the select Tools/Sort....

Then, with both spreadsheets open, use the VLOOKUP or HLOOKUP function
(see the help file). An example would be

=VLOOKUP(E13,[Book4]Sheet1!$A$5:$B$7,2,TRUE)

where:
E13 contains the value of the username,
Book 4 is the name of the spreadsheet containing the names,
Sheet1 is the sheet in the spreadsheet containing the names,
$a$5:$b$7 are the cells containing the usernames and names,
True means you want an exact match.

Hope this helps.