Reference Cell Name
 

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

Reference Cell Name
 

One way:

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

--
Biff
Microsoft Excel MVP


"LRay67" wrote in message
...
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