Vlookup doesn't execute

December 21, 2011 at 06:41:07
Specs: Windows XP
when i type a vlookup formula in a cell, it doesn't execute. I only see the formula typed out in a string format in the cell. For example:

=vlookup(........) would be in the cell instead of the result of the vlookup.

Please help.

See More: Vlookup doesnt execute

Report •

December 21, 2011 at 07:07:04
Go to File, Options, Advanced now look for "Show formula in cell instead of calculated results" and untick it

Report •

December 21, 2011 at 09:13:30
Does it happen with all functions or just VLOOKUP?

Does it happen is all cells or just one/a few?

Does it happen in all workbooks or just this one?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

Ask Question