Good morning!
I am sure there is an easier way to do this, but I have been banging my head against the wall trying to find a solution to no avail. I would greatly, greatly appreciate help.
I want to return a $ value in D2 (Sheet 1) to display the corresponding $ value from column D (Sheet 2) based on the date in C2 (Sheet 1).
Is this possible? Thank you.
(Sheet 1)
(Sheet 2)
Notes:
I am sure there is an easier way to do this, but I have been banging my head against the wall trying to find a solution to no avail. I would greatly, greatly appreciate help.
I want to return a $ value in D2 (Sheet 1) to display the corresponding $ value from column D (Sheet 2) based on the date in C2 (Sheet 1).
Is this possible? Thank you.
Notes:
- Row 31 can be ignored
- < 2021 means any date during or before 2021
- < June 2022 means any date during or before June 2022