Originally Posted by
JimDandy
<snip>can I concatenate "RentIncrease" and the right 2 characters from the header row to come up with RentIncrease1 or RentIncrease2?
If what you want to do is replace any formula which contains 'RentIncreaseX' with something which puts the X in automatically, try these:
In column D, instead of =L7*(1+RentIncrease1) try this:
and in column E onwards, instead of =D21*(1+RentIncrease2) (and similar), try this:
Is that something you can use with your file layout?
Regards,
Aardigspook
If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark Thread as Solved'.
You don't need to give me rep if I helped, but thanks are appreciated.
Bookmarks