Hi there, I have created the following formula but it does not return the correct row number:
MATCH(INDEX(List!G1:G1000000,MATCH(P4,List!H1:H1000000,0)),Ref!W1:W1000000)
In sheet Ref, the row number that it should return is 38748 but it returns 38866.
The value is a number that is in row...