After trying the suggestions All I got in Col E and F were the words
Kilometer and Miles. I neglected to say in my intial post that there is a
header row in both sheets.

--

Regards
Michael Koerner


"Michael Koerner" wrote in message
...
Thank you all. this is just great.

--

Regards
Michael Koerner


"Michael Koerner" wrote in message
...
I have a workbook that tracks my walking program. Sheet 2 named Routes
contains all the routes that I use for my runs.Col A contains the route
number. Col B & C contains the distance for that route in Kilometres and
miles. Col D contains the description of the route.

I would like in Sheet 1 (Current Year) to be able to insert the route number
in Col D and have the distance for that route in Kilometres and miles show
up in Col E & F.

Any help is greatly appreciated.

--

Regards
Michael Koerner