How to show the result instead of the function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I typed a fórmula with a function --> =VLOOKUP(XXX;XXXX;X) , but instead of seeing the result of the formula I just can see the formula itself when I validate i

Anyone know waht should I change in order to get it right

Thank

Alvar
 
Hi
1. check 'Tools - Options - view' that 'Formula' is NOT checked
2. Maybe your cell is formated as 'Text'. goto 'Format - Cells' and
change the format to 'General'. After this re-enter the formula

--
Regards
Frank Kabel
Frankfurt, Germany

alvaro said:
I typed a fórmula with a function --> =VLOOKUP(XXX;XXXX;X) , but
Click to expand...
instead of seeing the result of the formula I just can see the formula
itself when I validate it
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup function did not show the result but.. 2
The formula shows in cell but not the result 1
How to show all formulas of cells in cells (and not the calculated result) ? 10
Why does the formula show instead of the result? 3
VLOOKUP - 0 instead of # N/A 8
Function not evaluating 2
IF/VLOOKUP with #N/A results 6
Formula result showing 0 3

Back
Top