formula becomes text

K

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

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