I am running in circles trying to solve this issue - seemingly, in using MATCH() on an external cell reference, the value it returns caps itself at 14 even though data goes out to ~30. While I end up using this base function in much larger equations, the screenshots explain the basis of the issue:
Here is the Cell Reference Setup... all of column [Site] which has ~30 values:
I am trying to use a =MATCH([Site ID]@row , {PlanGrid Metrics Site})....
For example purposes, I am going to hardcode in Site ID:
We can see we get "7" as expected.
But trying anything past entry 9 or "FH" faults:
However, back checking the data incoming with INDEX(), it should be working:
I have tried resetting the cell reference with no luck. Does anyone know why this is happening?
The faulting MATCH() values do not seem to follow any pattern either:
Correct for external reference rows 1-8
For MATCH attempts rows 9-14 it returns "2"
For MATCH attempt row 15 "SCCC" we get a correct 15
Anything past "SCCC", MATCH returns a "14".
What adds a level of confusion is I can throw in values not within the external cell reference and get a return value of 2:
Any help is welcome
