Referencing different workbooks

  • Thread starter Thread starter jimmy
  • Start date Start date
J

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!!!
 
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).
 
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.
 
Back
Top