Hello I was wondering if someone could help me to create a distance calculator. At present I have a spreadsheet using vlookup formulas so where a person can choose a town froma drop down list and the distance to that town from a particular suburb will automatically be displayed with the vlookup formula.
However I want to add to this so the person can first choose a different from suburb then choose the TO suburb. For example at present my spreadhseet will only show the distance from Melbourne to the suburb chosen from the drop down list.
I want to be able to first choose the departure town so it might be Melbourne or Sydney or Perth, then the destination town and depending on this the distance between the two is shown in the cell.
I have a file containing my departure towns and the distances to each suburb from them.
Im just not sure how to do the first part so my vlookup formula for the destination will use a different range depending on what departure town was selected.
Any help would be appreciated.
Thanks heaps
Bookmarks