lookup data and fill cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding up total hours worked on employee schedule using various criteria 0
Lookup Question 7
Copy is criteria met 3
Vlookup finding subtotals only 5
remove fill in text from a cell from an unpopulated fill-in cell 1
Comparing 2 worksheets in Excel 2007 1
Data lookup function 2
Copy summary data to new sheet 1

Back
Top