formula becomes text

[kang]

there is a formula
=IF(ISERROR(VLOOKUP(A3691,A$1:A3690,1,FALSE)),"") &
IF(ISERROR(VLOOKUP(A3691,A3692:A$6867,1,FALSE)),"")

when I change A$6867 to A6967
the formula becomes text
I mean what I see is formula itself not the result
thanks.

 

[T. Valko]

Sounds like the cell is formatted as TEXT.

Select the cell in question.
Change the format to GENERAL then hit function key F2 then hit ENTER.