LinkBack URL
About LinkBacks
Pl see file and note the changes.
In E3 then drag across
=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,$D3*INDEX('Rent Roll'!$D$11:$H$11,MATCH(YEAR(E$2),'Rent Roll'!$D$9:$H$9,0)),D3)
Pl see file and note the changes.
In E3 then drag across
=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,$D3*INDEX('Rent Roll'!$D$11:$H$11,MATCH(YEAR(E$2),'Rent Roll'!$D$9:$H$9,0)),D3)
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks