View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Anna Anna is offline
external usenet poster
 
Posts: 132
Default Index Function Help

Can any one can help me to solve this I dont know why I get error #value
next to Reference in the Index Function argument window
=INDEX((A1:C6,A8:C11),2,2,2) even I got the error the result comes back ok
but with one area selected there is no problem
Thanks in advance
Anna