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 !

Hi

use the VLOOKUP function

in cell C2 sheet 1 type
=VLOOKUP(A2,Sheet2!$A$2:$B$20000,2,0)
this says lookup the value in A2 (ie High Street) in the table on worksheet
2 and return the inoformation in the second column where there is an exact
match.
and then fill down (move mouse over bottom right corner of C2 and when you
see the +, double click)

This, of course, assumes that you have only one High Street in one district.

Hope this helps
Cheers
JulieD

"Mr-Re Man" wrote in message
...
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 !

JulieD, THANK YOU - THANK YOU - THANK YOU

"JulieD" wrote:

Hi

use the VLOOKUP function

in cell C2 sheet 1 type
=VLOOKUP(A2,Sheet2!$A$2:$B$20000,2,0)
this says lookup the value in A2 (ie High Street) in the table on worksheet
2 and return the inoformation in the second column where there is an exact
match.
and then fill down (move mouse over bottom right corner of C2 and when you
see the +, double click)

This, of course, assumes that you have only one High Street in one district.

Hope this helps
Cheers
JulieD

"Mr-Re Man" wrote in message
...
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 !

Hi Mr-Re Man

you're VERY welcome :)

and thanks for the feedback

Cheers
JulieD

"Mr-Re Man" wrote in message
...
JulieD, THANK YOU - THANK YOU - THANK YOU

"JulieD" wrote:

Hi

use the VLOOKUP function

in cell C2 sheet 1 type
=VLOOKUP(A2,Sheet2!$A$2:$B$20000,2,0)
this says lookup the value in A2 (ie High Street) in the table on
worksheet
2 and return the inoformation in the second column where there is an
exact
match.
and then fill down (move mouse over bottom right corner of C2 and when
you
see the +, double click)

This, of course, assumes that you have only one High Street in one
district.

Hope this helps
Cheers
JulieD

"Mr-Re Man" wrote in message
...
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 !