J
Joe
My spreadsheet is setup as follows:
Column
A B C D
E
County Road Starting Mileage Ending Mileage Road Type
Alan 52 0 5
Highway
Alan 52 5 12
Local Road
When I enter the County, Road, and Mileage point, I want Excel to return to
me the road type. So if I enter Alan-52-3, it will return a value of
"Highway". If I enter Alan-52-7, it would return a value of "Local Road".
How do I do an index/match (or other function) that can search through
columns C & D to determine what mileage point I'm specifically at?
Column
A B C D
E
County Road Starting Mileage Ending Mileage Road Type
Alan 52 0 5
Highway
Alan 52 5 12
Local Road
When I enter the County, Road, and Mileage point, I want Excel to return to
me the road type. So if I enter Alan-52-3, it will return a value of
"Highway". If I enter Alan-52-7, it would return a value of "Local Road".
How do I do an index/match (or other function) that can search through
columns C & D to determine what mileage point I'm specifically at?