On Sep 3, 9:16 am, Kmurray wrote:
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.

Check to see if the cell is formatted as Text. Or press CTRL-`, see
what happens. Press it again if it doesn't help. The ` key is above
the Tab key on a USA keyboard.