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...
 
Back
Top