LinkBack URL
About LinkBacks
RKP 
Revised formula
=IF((MOD(YEAR(E$2)-YEAR($D$2),INDEX('Rent Roll'!$D$3:$D$5,MATCH($C3,'Rent Roll'!$C$3:$C$5,0)))=0)*(MONTH(E$2)=6),$D3*(INDEX('Rent Roll'!$G$3:$K$5,MATCH($C3,'Rent Roll'!$C$3:$C$5,0),MATCH(YEAR(E$2),'Rent Roll'!$G$1:$K$1,0))),D3)
Revised formula
=IF((MOD(YEAR(E$2)-YEAR($D$2),INDEX('Rent Roll'!$D$3:$D$5,MATCH($C3,'Rent Roll'!$C$3:$C$5,0)))=0)*(MONTH(E$2)=6),$D3*(INDEX('Rent Roll'!$G$3:$K$5,MATCH($C3,'Rent Roll'!$C$3:$C$5,0),MATCH(YEAR(E$2),'Rent Roll'!$G$1:$K$1,0))),D3)
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Hi,
Thanks. However, it is not exactly what I needed as I want the indexation to take place only 31.03.xx each year. So If the analysis date is 31.03.xx - that's why I had 1.00 in cell: "E12:G12".
Can you amend so this is taken into account?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks