VLOOKUP

sheet1
ColA Col B
ACC# ACC NAME
Acc#92 =VLOOKUP(A2,Sheet2!A:B,2,FALSE)
Acc#56 =VLOOKUP(A3,Sheet2!A:B,2,FALSE)
etc etc

sheet2
ColA Col B
ACC# ACC NAME
Acc#1 Microsoft
Acc#2 IBM
Acc#3 Dell
etc
--
Allllen


"fawkes1" wrote:

I have 1 sheet that has a column containing many different account numbers.
I have a 2nd sheet with the same account numbers with the relevant account
name. I would like to add a column on the 1st sheet which looks up the
account number on the 2nd sheet and brings back the account name. Both
sheets have varying numbers of rows which change from month to month. The
2nd sheet has all possible account numbers, and the 1st only has account
numbers used that month.