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

S

Sweetetc

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)
 
Top