Hi, I was wondering if a formula for the following is possible,

In worksheet 1, column A I have a road name and in column B the type of work
that is carried out at the road name. Then on worksheet 2 I have the road
name and district it is in, what I am after is for the district to be put in
column C on Worksheet 1 without me having to type them in as I have 15000
rows of data.

Worksheet 1
A B
ROAD NAME TYPE OF WORK
High Street Grass
High Street Hedges
Low Road Grass
Low Road Hedges
Low Road Roses

Worksheet 2
A B
ROAD NAME DISTRICT
High Street Malpas
Low Road Risca
Middle Close Newport

Is this possible?

Anyone who could help me, would be saving me hours of monotonous replication.

Thanks in anticipation !