Howdy all. Having issue with relative reference in a named formula.
I have attached the spreadsheet for easier reference. Basically I want to have one named "master" formula on a VALIDATION sheet, then apply that formula via name to to multiple cells over 12 other sheets. The problem I am running into is I need the named formula to pull it's values from the two columns next to the current cell and not the original named formula's cell. I have tried relative reference and using OFFSET, but still get a circular reference. Any thoughts on what I am doing wrong?
Bookmarks