Hide Circular Reference Arrows

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!

I presume it is a formula if it is supposed to calculate from the other cell and it is a value if the user has typed over it?

In that case how about -

Please Login or Register  to view this content.

and then wrap your formula in a IF(isformula(), ,) sort of statement.

That is a great idea. Thank you!

I am trying to avoid any custom functions or VBA as I don't want to save it as a .xlsm file but I will keep that in mind.

well... otherwise you could enable iterative calculations under formulas in the options if you have access to all those settings that is for the users.

To enable iterative calculations I would have to do so programmatically; manually adjusting everyone's settings is unfeasible. I am trying to avoid the use of VBA for this workbook.

If I am going to save it as an .xlsm, I will just do this:

Please Login or Register  to view this content.

For this particular project, it is important that there are only two fields visible and the fields show the correct information based on either input.

I tried setting up the lookups in hidden helper columns and then using =IF(LOOKUP_VALUE<>"",LOOKUP_VALUE,"") in the visible fields but this still generated a circular reference.

Thank you for your help.

Personally I'd be trying to avoid the actual circular reference errors as well as just the arrows.

Maybe if we saw the example in context it might help.
this sounds like it might be a protected sheet. Can you have a very narrow column next to the one you enter the data in that has the formula so that whenever they enter in the data it hides the formula one? (and of course make the other column un-selectable)

I am heading home for the day now but I will upload an example tomorrow.