Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup / Index/Match
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if/lookup/index/match? | Excel Worksheet Functions | |||
index/match/lookup??? | Excel Discussion (Misc queries) | |||
index match lookup | New Users to Excel | |||
Match Index Lookup | Excel Discussion (Misc queries) | |||
lookup (v,h,index,match) | Excel Worksheet Functions |