Thread: formula becomes text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
kang kang is offline
external usenet poster
  
Posts: 38
Default formula becomes text
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.
Reply With QuoteReply With Quote