I have Dates running from A3 - A367 (the whole year) In B1-D1 I have the names Mick, Mike and Michael. Mick, Mike and Michael travel from city to city and each time they move I place the city name in the corresponding date cell. I wish for their current location to be shown in B2-D2.
Can...