linking data from 2 wrksheets using a common cell value
 

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.

linking data from 2 wrksheets using a common cell value
 

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.

"jmasterton" wrote:

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.

linking data from 2 wrksheets using a common cell value
 

Perfect! Thanks so much!!

"Sean Timmons" wrote:

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.

"jmasterton" wrote:

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.

linking data from 2 wrksheets using a common cell value
 

Not a problem!

"jmasterton" wrote:

Perfect! Thanks so much!!

"Sean Timmons" wrote:

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.

"jmasterton" wrote:

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.