Forum Discussion
Help with a milage log
I am trying to create a sheet with drop downs for destination that would insert the correct mileage between the destinations. I have a cross reference mileage matrix on a sheet with the destinations ...
You may apply data validation list as
and use
=INDEX( Mileages, MATCH(G4,Mileages[Mileages], 0), MATCH(H4, Mileages[#Headers], 0 ) )to get mileage.