I've run into an interesting problem concerning an absolute cell reference that I'm stuck on and not sure if there is even a work around for it.
H11 is a Data Validation List
Beginning with L11, an nested IF along with an INDEX statement are used to apply a Target Book to Look to the calculations that are used in Columns L and M based on the data in H11.
The problem is that starting with L20, in this attached example, It uses the value in H11 and NOT H20. I understand this is because of the absolute cell value, but I need the reference to Region (H11, H20, H29) to copy down properly when I copy/paste down the sheet.
Hope this makes sense and thanks in advance for the help. Any combination of cell reference formulas I can use to make this easier when I copy down the sheet?