Hi all.
I know I've a workbook someplace with what I'm trying to achieve here already in it, but for the live of me I can't find it.
Anyways, here goes, and I know it'll be something simple.
I have a workbook I fill in daily specifying date (Col A) start location (Col B) and end location (Col C) along with the distance (Col D) between the 2.
I have a 2nd sheet called Distances, which already has a list of these trips and their lengths, with start location (Col A) and end location (Col B) along with the distance (Col C)
What I am trying to is when I input Start & End locations that Distance will be automatically filled in based on these 2 cells.
All help greatly appreciated.
I know I've a workbook someplace with what I'm trying to achieve here already in it, but for the live of me I can't find it.
Anyways, here goes, and I know it'll be something simple.
I have a workbook I fill in daily specifying date (Col A) start location (Col B) and end location (Col C) along with the distance (Col D) between the 2.
I have a 2nd sheet called Distances, which already has a list of these trips and their lengths, with start location (Col A) and end location (Col B) along with the distance (Col C)
What I am trying to is when I input Start & End locations that Distance will be automatically filled in based on these 2 cells.
All help greatly appreciated.