hi guys,
I need some help with a formula, I have a value 8319 and date 02-Feb-18, I would like to the formula to return the result of column D, if it can find a match of Column A and also within the date range of Column B and C......
<tbody>
</tbody><colgroup><col><col span="2"><col></colgroup>
thanks in advance.
Cheers,
Joe
I need some help with a formula, I have a value 8319 and date 02-Feb-18, I would like to the formula to return the result of column D, if it can find a match of Column A and also within the date range of Column B and C......
# | From Date | End Date | Result |
8319 | 1-May-17 | 31-Dec-17 | A |
8319 | 1-Jan-18 | 10-May-18 | B |
8319 | 15-May-18 | 30-May-18 | T |
<tbody>
</tbody><colgroup><col><col span="2"><col></colgroup>
thanks in advance.
Cheers,
Joe