Limit on Match

  • Thread starter Thread starter Marcelluss
  • Start date Start date
M

Marcelluss

Hello,


I'm using

=INDEX(EQzones!$B$8:$B$2000,MATCH(D5, EQzones!$A$8:$A$2000))


to match data from another page and it works fine with the data alread
on the worksheet. However, if I copy and paste more over for it t
reference it will "NA". I have this formula in about 1000 cell
starting at D5. I don't know what is wrong.

Thank you
 
Look at the help for match
You probably want to change the formula to:
=INDEX(EQzones!$B$8:$B$2000,MATCH(D5, EQzones!$A$8:$A$2000,0))
because the copy-paste information is not sorted properly.
 
Back
Top