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.