Thread: #N/A
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 390
Default #N/A

I have a column with 20 rows and I am entering this function
=INDEX(Av$6:Av$25,MATCH(ROW()-1,$ax$6:$ax$25,)) in the first row then I copy
down till the 20th row. Why from the 17th row it is giving me #N/A.