"I got this error when I added a vlookup to the sheet. Make sure that you don't have any vlookups on the same sheet that has the dynamic ranges. It seems to brek the dynamic range function. My workaround is that I put the vlookup on a different…"
"You cannot have vlookups anywhere on the sheet that has the dynamic ranges. The workaround is to have the vlookup on a different sheet. Then on the sheet that has the dynamic ranges, simply reference the other sheet & cell that has the…"
"I'm not quite sure how this would work. I made an attempt but pretty sure I am doing it wrong. I'm attaching an excel file that shows the formulas I am using in my template row so you can see what I am attempting. "