title: Header value to be returned based on "Current Date" column
body: <p><a href="https://i.stack.imgur.com/HYDS5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/HYDS5.png" alt="Role Selection" /></a></p>
  <p>I have been looking for this formula but could not figure for quite a while.</p>
  <p>We have growing team that will periodically move to a new position based on their performance.</p>
  <p>I need to have the updated &quot;Role&quot; based on the &quot;Updated Date&quot;.</p>
  <p>Logic for first sample at column H:K.</p>
  <p>Date stated from column C - E would be their effective date.</p>
  <p>For rep 1, he was effectively as Focal from 1 Jun, moved to Call on 1 Jul and move to Lateshift on 1 Aug till now.</p>
  <p>Rep 1 was a &quot;Call&quot; team on 3 July hence current role = Call</p>