New problem I think it is associated with the Excel options.
In the past week I have been having issues with myVLOOKUP function.
Sometimes it will not change to reflect the answer. While writing the
formula, I can see the answer that should appear, but once I hit the ok
button, the formula is all that you see. I know this has to be something
simple that I don't see. I have looked at options for excel, but see nothing
that would stop the formula from hiding and the result appearing.