Auto-fill next cell Question

[JackWatson]

This is probably going to require at least a macro, if not VBA.
In Sheet 1, I have a list of items in column A (delivery route) with a co-responding value in column B (distance). The value is static.
What I want to do on Sheet 2 is when I enter the name of the route, it auto-populates the distance in the next column (or a designated cell or cells). So if on Sheet 1 I have a route called "Airport" and that route is 13 miles, if I type "airport", the next column over will automatically show 13.
As an added bonus, I wonder if I can enter a short name (i.e. "air" instead of "airport") and have the cell either automatically change to airport (auto-correct, maybe?), or have airport pop up the next column over and then 13 automatically pop up one more column over.
I'm not very good at macros; I can use the recorder and do a little fine tuning in the code, but VBA, I'm completely lost, but I hope someone can give me an idea.

Much obliged.

[Pete_UK]

Assuming you have typed Airport in A1 of Sheet2, then you can have this formula in B1:

=IFERROR(VLOOKUP(A1&"*",Sheet!A:B,2,0),"")

The asterisk will allow you to enter abbreviations, e.g. "air" instead of airport, but it might give unpredictable results. For example, if you have another entry on Sheet1 which starts with air (like Air Products Factory), then the formula will only return the distance for the first matching entry it finds, so you need to ensure that the number of letters entered in A1 will uniquely define the item that you want (i.e. "airp" for airport, and "Air P" for the factory - case does not matter).

Hope this helps.

Pete

[JOHN H. DAVIS]

Try this too see if it does what you want.

[JackWatson]

Thanks, John, for the starting point. How did you do that? Like I said, my VBA experience is virtually nil, and macro so-so, but once I see how it works, I pick it up fairly quickly.

[JOHN H. DAVIS]

Right click on your sheet tab. Select view code. There is where the macro is included.