I have a lookup list on sheet two set up to show the following drop down list on sheet 1:
0-3 months
3-6 months
6-9 months
9-12 months
On sheet 1 this list appears twice on each record, for example:
6-9 months
0-3 months
I need a formula that will look at the two cells on sheet 1 and enter the shortest time period and display it in a third cell on sheet 1, in this instance:
0-3 months
I have checked out IF functions and VLookup and I can't figure out how to do this as the contact is text and not numeric.
Can anyone point me in the right direction please and advise which function I should use, it its possible? I have searched high and low and have been unable to find anything similar.
Any help would be appreciated.
0-3 months
3-6 months
6-9 months
9-12 months
On sheet 1 this list appears twice on each record, for example:
6-9 months
0-3 months
I need a formula that will look at the two cells on sheet 1 and enter the shortest time period and display it in a third cell on sheet 1, in this instance:
0-3 months
I have checked out IF functions and VLookup and I can't figure out how to do this as the contact is text and not numeric.
Can anyone point me in the right direction please and advise which function I should use, it its possible? I have searched high and low and have been unable to find anything similar.
Any help would be appreciated.