My formula show up in the cell instead of a resulting value

G

Guest

I have a look up formula
=VLOOKUP($A2,AFT_CDSCLIAB_LAC!$A:$X,9,FALSE)-VLOOKUP($A2,BEF_CDSCLIAB_LAC!$A:$X,9,FALSE)

Instead of showing the resulting value it displayes the formula
 
N

Niek Otten

Your cell was formatted as text before you entered the formula.
Format as General and RE-ENTER THE FORMULA (F2, ENTER)
 

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

Searching the formula (not the value) for a text string 1
ISNA Formula returning "False" instead of value 4
Lookup against concatenated source value 2
blank cell return vs. a 0 8
Vlookup, replace true text result with "X" 5
HELP!!!!!!!!! 2
formula referring to a worksheet 3
VLOOKUP 1

Top