linking data from 2 wrksheets using a common cell value

[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.

 

[Sean Timmons]

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]

Perfect! Thanks so much!!

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.

 

[Sean Timmons]

Not a problem!

Perfect! Thanks so much!!