Have columns with mileages from one starting point to another to figure the
shortest distance

Ex: Column A - Main Address
Column B - City
Column C - ending address with mileage in row 2
Column D - different ending address with mileage in row 2
Column E - minimum mileage using =min(C2:D2) function
Column F - how do I capture the contents - the header which is the
ending address of column C1 and D1 depending on column E return of the
minimum mileage?

Anyone have any clues?

Thanks

Linda