Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Some kinda lookup
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 ! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I lookup and return different values when the lookup value. | Excel Discussion (Misc queries) | |||
How to lookup data in a row and column | Excel Discussion (Misc queries) | |||
need check two worksheets to lookup a value | Excel Discussion (Misc queries) | |||
Excel Lookup Functions | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |