I want to find the value in A1 in column F and return the corresponding date in column E in cell A2 as shown below. I am trying to avoid creating a lookup table and vlookup to do it. Column E and F have duplicates so I just need the date upon the first match of the value.
<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>
</tbody>
<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody> </tbody> |
<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>
</tbody>