I am trying to automate a rent increase on a certain date. I have a table with Tenant ID, Rent Increase Date, New Rent amount. I would like to reference this in another sheet, so that when the rent increase date arrives, it will return the new rent amount.
I can use the Index and Match to pull in the amount, just needing it to update on a certain date is what is giving me trouble.
Any point in the right direction would be appreciated.