linking data from 2 wrksheets using a common cell value

  • Thread starter Thread starter jmasterton
  • Start date Start date
J

jmasterton

What I have:
1 sheet 2 columns: customer name and legislative district number
1 sheet 3 columns: legislator name, postal address, and legislative district
number

What I need:
1 sheet showing each customer, their legislative district number and the
name and address of the legislator for that particular district

Any help would be appreciated.
 
So, on sheet1, do an index with match..

=INDEX(sheet2!$A$1:$Z$5000,MATCH(B2,sheet2!$C$2:$C$5000),1) gets you name.
=INDEX(sheet2!$A$1:$Z$5000,MATCH(B2,sheet2!$C$2:$C$5000),2) gets your address.

this assumes there is one record per district number.
 
Perfect! Thanks so much!!

Sean Timmons said:
So, on sheet1, do an index with match..

=INDEX(sheet2!$A$1:$Z$5000,MATCH(B2,sheet2!$C$2:$C$5000),1) gets you name.
=INDEX(sheet2!$A$1:$Z$5000,MATCH(B2,sheet2!$C$2:$C$5000),2) gets your address.

this assumes there is one record per district number.
Click to expand...
 

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

Excel Changing chart label colors based on a value in a cell 0
Linking labels in a pivot table 1
Data Design Question 2
Excel print area which only prints pages of worksheet which are active 0
Difficulty with Sum+IF Function 10
Counting # of cells with that meet criteria in two columns 7
Access SQL to Transact-SQL help please 2
I know this is simple but ans= and nothing happens 1

Back
Top