samickelson01
New Member
- Joined
- Apr 5, 2019
- Messages
- 2
I'm not an Excel expert and my HelpDesk hasn't been able to figure it out either so I searched for experts, and this forum came up! Here is my issue:
I'm trying to solve for the cell "????" below. The 2 cells above it are entered so I'm trying to find the July 2018 row that has the date 7/25/19 in it.
7/25/19 falls in July 2018 Term 4, August 2018 Term 3, and October 2018 Term 3 but I need that cell to look at A1 and A2 and populate with the corresponding Term (Term 4 in this example).
I've tried to use INDEX MATCH, and IFLOOKUP, and INDEX MATCH IF and I can't seem to find the right combination to consistently return the correct result.
Any ideas on a formula??
<tbody>
</tbody>
I'm trying to solve for the cell "????" below. The 2 cells above it are entered so I'm trying to find the July 2018 row that has the date 7/25/19 in it.
7/25/19 falls in July 2018 Term 4, August 2018 Term 3, and October 2018 Term 3 but I need that cell to look at A1 and A2 and populate with the corresponding Term (Term 4 in this example).
I've tried to use INDEX MATCH, and IFLOOKUP, and INDEX MATCH IF and I can't seem to find the right combination to consistently return the correct result.
Any ideas on a formula??
July 2018 | July 2018 | Term 3 | 3/6/19 | 7/17/19 |
---|---|---|---|---|
7/25/19 | July 2018 | Term 4 | 7/22/19 | 11/20/19 |
???? | August 2018 | Term 2 | 12/15/18 | 4/10/19 |
August 2018 | Term 3 | 4/11/19 | 9/10/19 | |
October 2018 | Term 2 | 3/9/19 | 6/5/19 | |
October 2018 | Term 3 | 6/8/19 | 10/14/19 |
<tbody>
</tbody>