Lookup

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

Guest

I have 2 spreadsheets. One is a database of all our dealer codes and the
state they are located in. The other is a list of all dealer codes that took
part in a promotion. I would like to add a column to the 2nd spreadsheet and
have excel look up each dealer code and insert which state they are in.
 
Use VLOOKUP.
=VLOOKUP(CodeToLookup,sheet1!YourDatabase,2,0)
Copy down as necessary.

Example
The database here is A1:B10 on Sheet1. The answers to be returned in Column
B on Sheet2, based on the Codes kept in Sheet2 Column A.
On Sheet2 in cell B1:

=VLOOKUP(A1,Sheet1!$A$1:$B$10,2,0)
Copy down as necessary.

tj
 

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

Copying rows of data into new worksheet but placing data into colu 1
Bargain Assassins Creed Origins with Samsung SSD's 4
Is it even possible?!? Importing web data.. 2
Merge Two Spreadsheets 3
Complicated V-lookup 4
Lookup function 5
Sales per dealer code 5
Do I need Excel or Access for my database needs? 3

Back
Top