|First, a couple of posting tips:|
1 - When you use the pre tags, you have to put a slash before the one at the end of your data to turn them off
<pre > Your Data </pre > (without the spaces, of course)
2 - You should include Column letters and Row numbers so we can reference your data by its location.
In this case, I'll assume your Route Info data starts in A1.
insert a helper column to the left of your Route Info data so that you'll have a new Column A.
Put this formula in the new A1 and drag it down so that you get just the first 3 numbers from Column B.
Now you can use VLOOKUP in the Master sheet to pull the Route Info data in.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.