Linking info from other worksheet

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I need to link some info. I have a worksheet with all my account numbers in
column A, with all the corresponding account names in column B. I have
another sheet in the same workbook that I am keying miscellaneous information
regarding these accounts. I would like to key the account number in column A
in this other sheet and have the corresponding account name automatically
show up in the corresponding cell in the B column. Any help would be greatly
appreciated.
 
Hi,
VLOOKUP is best, but won't lookup tables from another sheet unless you mane
the table. So, name Columns A and B in sheet1, then use VLOOKUP in sheet 2
using the name instead of the reference.
See help for naming a range if necessary.
Regards - Dave.
 
Dave

Although a named range is always easier to work with it is not necessary to name
the table on the other sheet.

=VLOOKUP(A1,Sheet2!$A$1:$B$20,2,FALSE) will do.


Gord Dibben MS Excel MVP
 
Oops,
Sorry Gordon. Had a mind block. I realize I was thinking of Data Validation
Regards- Dave.
 
Back
Top