How Do I

[Michael Koerner]

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.

 

[Lars-Åke Aspelin]

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.

Assuming the route numbers are sorted, try the following formulas.

In cell E1: =VLOOKUP(D1,Routes!A$1:B$100,2)
In cell F1: =VLOOKUP(D1,Routes!A$1:C$100,3)

If the route numbers are NOT sorted you have to use

In cell E1: =VLOOKUP(D1,Routes!A$1:B$100,2.FALSE)
In cell F1: =VLOOKUP(D1,Routes!A$1:C$100,3,FALSE)


Change the 100 to fit the size of your data in sheets Routes.
Copy cells E1:F1 down as far as you have data in column D.

Hope this helps / Lars-Åke

 

[BSc Chem Eng Rick]

Use VLOOKUP.

In col E use : =VLOOKUP(D1,Routes!A:C,2,0)
In col F use : =VLOOKUP(D1,Routes!A:C,3,0)

If this helps, please click "Yes"
<><><><><><><><><><><><>

 

[Mike H]

Hi,

With the route number in D1, put this in E1 and drag left into F1. You can
also drag it down to display more diestances for other routes in column D

=IF(D1<>"",VLOOKUP($D1,Routes!$A$1:$C$10,COLUMN(B2),FALSE),"")

Mike

 

[Michael Koerner]

Thank you all. this is just great.

--

Regards
Michael Koerner


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.

 

[Michael Koerner]

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


Thank you all. this is just great.

--

Regards
Michael Koerner


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.

 

[Michael Koerner]

I figured it out. Again, thanks to everyone.

--

Regards
Michael Koerner


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


Thank you all. this is just great.

--

Regards
Michael Koerner


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.