Here is my formula.
=INDEX(Tracker2!C$72:C$151,MATCH('Field Results Data'!$A14,Tracker2!$A$72:$A$151)+2,1)
The index is all the data between C72 and C151. I only need column C so this is ok, and the data is actually within 72 to 130 so there is no issue with missing off what i need.
The match is A14 which is to the left and is an ID, eg ABC123.
and tracker 2 A72-A151 is where all the IDs are kept.
the first 2 columns in the tracker data are empty which is why I have +2 to get the 3rd row after the ID.
I have this formula repeated on several pages and it works for all but the last 1 or 2 every time. Surely if its working for the first 8 or 9 it cannot be a formula issue. So confused!!!
Any ideas?
=INDEX(Tracker2!C$72:C$151,MATCH('Field Results Data'!$A14,Tracker2!$A$72:$A$151)+2,1)
The index is all the data between C72 and C151. I only need column C so this is ok, and the data is actually within 72 to 130 so there is no issue with missing off what i need.
The match is A14 which is to the left and is an ID, eg ABC123.
and tracker 2 A72-A151 is where all the IDs are kept.
the first 2 columns in the tracker data are empty which is why I have +2 to get the 3rd row after the ID.
I have this formula repeated on several pages and it works for all but the last 1 or 2 every time. Surely if its working for the first 8 or 9 it cannot be a formula issue. So confused!!!
Any ideas?