Quick and easy: Is there a way to hide the circular reference arrows which appear randomly as I use my worksheet? Preferably a workbook setting I can adjust to avoid saving as a macro-enabled workbook and open that whole security can of worms when others try to use it.
If not...
I made the circular reference intentionally. It is two VLOOKUP formulas which reference each other, allowing the user to enter either one of the values and the corresponding value is looked up. As soon as the user enters either value, the circular reference is broken. This works fine and is completely intentional. The problem is: the circular reference arrows show up randomly on unused lines. Only one arrow shows at a time and which row shows the arrow seems to be arbitrary. Any suggestions on how to recreate this functionality without using a circular reference or VBA? I'm sure this will seem so straightforward and simple tomorrow morning but I go brain dead after 3:00 p.m.
Thank you!
Bookmarks