A B C

1 urban local 10

2 urban collector 20

3 rural local 30

4 rural collector 40

let say i want to find the value when my road 1 is a rural collector...

Inventory:

X Y Z

1 name environtment roadtype

2 1 rural collector

...

how could i create a formula to do so... without using "if" because my table is much larger than this one...

maybe an index/match combo could work???

thank you in advance