Function displays as text, doesn't return result or error
 

When I export data from QuickBooks to an Excel spreadsheet, the function
feature appears to be turned off. I type a correct syntax function into a
cell, preceded by an "=", formatted as "general" and with the "option"
function view turned off, and the following is displayed instead of the
result:

=VLOOKUP(D2,Sheet2!A2:B11,2)

Literaly, it just shows me what I typed. I KNOW there is a switch somewhere
that QuickBooks turned off in this workbook... For the life of me I can't
find it.

Function displays as text, doesn't return result or error
 

You might have calculation mode set to manual - go to Tools | Options |
Calculation (tab) and ensure that Automatic is checked.

Hope this helps.

Pete

SOLVED!: Function displays as text, doesn't return result or erro
 

Apparently, the cell I was referencing for the lookup value was formatted as
"text," so Excel "helpfully" auto-formatted the cells containing the
referencing functions as "text." Voila! typed formula instead of a result.

I went back and made sure that all reference cells were formatted GENERAL.
Life is good again...


"Pete_UK" wrote:

You might have calculation mode set to manual - go to Tools | Options |
Calculation (tab) and ensure that Automatic is checked.

Hope this helps.

Pete