Linking info from other worksheet

[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.

 

[Dave]

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.

 

[Gord Dibben]

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

 

[Dave]

Oops,
Sorry Gordon. Had a mind block. I realize I was thinking of Data Validation
Regards- Dave.

 

[Mike]

Thanks for your help guys, I will give it a shot.