Hi All,
I am trying to work out a formula which allows me to return a value from a table based on 2 criteria with partial word match. I have an example below.
I would greatly appreciate any assistance!
Thanks
<tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
I would like to return a value from Fruit (month) column based on word typed in Group if date sits between that particular fruit's start and end date
I am trying to work out a formula which allows me to return a value from a table based on 2 criteria with partial word match. I have an example below.
I would greatly appreciate any assistance!
Thanks
Group | Date |
Apples | 10/2/18 |
<tbody>
</tbody>
Fruit (month) | Start Date | End Date |
Apples (Jan) | 1/1/18 | 30/1/18 |
Apples (Fab) | 1/2/18 | 25/2/18 |
Apples (Mar) | 1/3/18 | 30/3/18 |
Bananas (Feb) | 1/2/18 | 29/2/18 |
Oranges (Feb) | 4/2/18 | 20/2/19 |
<tbody>
</tbody>
Fruit (month) |
<tbody>
</tbody>
I would like to return a value from Fruit (month) column based on word typed in Group if date sits between that particular fruit's start and end date