Hi all,
I am struggling to come with an equation for the following problem. Below is a table to illustrate.
<tbody>
</tbody>Let's first look at the Bold Table.
I have a series of time periods with start and end dates. Below the Start and End dates are a set of $ values.
Below the bold table is a set of dates. Now I want to be able to return a value that if the cell says "Net" and a Date falls within the period it will return the specified period value of the first row $ amounts. If the Bold Says "Base Year" and a Date falls within the period it will return the specified period value of the second row $ amounts.
Its seems what I am looking to do is have an If statement followed by an hlookup of a value inbetween the array of bolded start and end dates
Sounds confusing, but I hope that makes sense to somebody who gan help
I am struggling to come with an equation for the following problem. Below is a table to illustrate.
7/1/2018 | 7/1/2019 | 7/1/2020 | 7/1/2021 | |
RE Taxes | 6/30/2019 | 6/30/2020 | 6/30/2021 | 6/30/2022 |
$1.16/SF | $1.19/SF | $1.23/SF | $1.27/SF | |
$0.16/SF | $0.19/SF | $0.23/SF | $0.27/SF | |
Net/Base Year | ||||
Date | RE Taxes per SF | Total RE Taxes | ||
Expense | Income | Expense | Income | |
4/1/2018 | #N/A | -$3,454.57 | #N/A | #REF! |
5/1/2018 | #N/A | -$3,454.57 | #N/A | #REF! |
6/1/2018 | #N/A | -$3,454.57 | #N/A | #REF! |
7/1/2018 | #N/A | -$3,454.57 | #N/A | #REF! |
8/1/2018 | #N/A | -$3,454.57 | #N/A | #REF! |
<tbody>
</tbody>
I have a series of time periods with start and end dates. Below the Start and End dates are a set of $ values.
Below the bold table is a set of dates. Now I want to be able to return a value that if the cell says "Net" and a Date falls within the period it will return the specified period value of the first row $ amounts. If the Bold Says "Base Year" and a Date falls within the period it will return the specified period value of the second row $ amounts.
Its seems what I am looking to do is have an If statement followed by an hlookup of a value inbetween the array of bolded start and end dates
Sounds confusing, but I hope that makes sense to somebody who gan help