Excel - vlookup with multiple conditions

I'm trying to do a lookup in Excel based on the following. Situation - I want to look up what the speed limit is in a given section of road.

Essentially the table I'm looking up specifies that the speed limit is, say, 50, from road position 0-123, then 60 from road position 123-500. The table has road_id, start_pos, end_pos, speedlimit.

On another sheet, roadid and position are entered.

I want to lookup 'speedlimit' from the row where roadid=road_id AND position>start_pos AND position

I have tried the following but Excel doesn't like the greater than / less than signs.

=INDEX(speed limit column,MATCH(roadid&<position&>position,road_id&start_pos&end_pos,0)

Recent Questions...