Share via

Function not activated

Anonymous
2016-11-18T14:52:44+00:00

I have a problem in Excel 13. In some spreadsheet from outside, I try to use any formula like

=VLOOKUP(B3;Oppslag1;5;FALSE)

I get no results. Only the formula itself. It seems like the function is not activated.

If i copy the stuff in a new spreadsheet, it seems to work.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2016-11-18T14:58:36+00:00

This suggests the cell has been formatted Text.

Format it General, click on it an use F2 to go to edit mode, then press Enter

best wishes

Was this answer helpful?

0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-11-18T22:41:42+00:00

    This suggests the cell has been formatted Text.

    Format it General, click on it an use F2 to go to edit mode, then press Enter

    best wishes

    Hi Bernard

    Thank you very much. It worked. I was afraid that it was so simple, but after hours of wading through help-files, you fixed.

    Thank you. I'm very grateful.

    Was this answer helpful?

    0 comments