Reference Cell Name

[LRay67]

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(C22) 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

 

[T. Valko]

One way:

=IF(C2=MIN(C2,D2),C1,D1)