Thread: Formula gives me the same answer
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wanna Learn Wanna Learn is offline
external usenet poster
  
Posts: 318
Default Formula gives me the same answer
=IF(ISERROR(VLOOKUP(E56,'Sales Report '!$1:$65536,12,FALSE)),"
",VLOOKUP(E56,'Sales Report '!$1:$65536,12,FALSE))

Hello , the above formula always gives me the same answer, the answer to
cell E56 is 12, when I copied the formula all the way down that answer is
still 12
what's going on? thanks
Reply With QuoteReply With Quote