Learning VLOOKUP in Excel

=VLOOKUP(E1,unvalidroutes!$A$1:$A$8,1,FALSE)

E1 is the field that you want to do the search/filtering

unvalidroutes!$A$1:$A$8 - this is the filtering table, that you want to match against

use $ sign to "lock" the filtering table

1 is the index number that you want to have once there is a match

False means exact match

Reference: http://www.timeatlas.com/5_minute_tips/general/learning_vlookup_in_excel