Some kinda lookup

[Mr-Re Man]

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]

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]

JulieD, THANK YOU - THANK YOU - THANK YOU

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

 

[JulieD]

Hi Mr-Re Man

you're VERY welcome

and thanks for the feedback

Cheers
JulieD