I'll assume that Alan is in cell F2, 52 is in cell F3, and 7 is in cell F4.
Overall "lookup" formula is:
=INDEX(E:E,SUMPRODUCT(--(A2:A100=F2),--(B2:B100=F3),--(C2:C100<=F4),--(D2:D100=F4),ROW(A2:A100)))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Joe" wrote:

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?