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.
 

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

Select Text to End of Footnote 9
Help With VLOOKUP 2
vlookup formatting problem 1
Change a great number of words in word files, with a macro as short as possible. 5
Searching the formula (not the value) for a text string 1
Can I add a formula or function to Vlookup? 1
excel formula is returning incorrect values 0
VLOOKUP FORMULA EVALUATION NEEDED 3

Top