Forum Discussion
Same XMATCH formula stopped working when I updated data.
A month ago, I used the following formula to find an exact match in a column on a different tab with 259,999 rows and it worked.
=XMATCH (A3,'EPC - 09-4-25'!B$1:B$250000)
I copied over the list of 250,000 with updated information. The formula does not work and returns #NA.
=XMATCH (A3,'EPC - 09-4-25'!B$1:B$250000)
Any suggestions for what could be wrong?
1 Reply
Hi
"...a column on a different tab with 259,999 rows and it worked". Even if it worked you should adjust your range from B$1:B$250000 to B$1:B$260000
A possible reason this doesn't work anymore could be due to the copy with updated info. you made, resulting in a mismatch between the data Types (Number, Text...) in A3 and in your 'EPC - 09-4-25'!B$1:B$250000 range
Ex.: Assume you enter 5 (a Number) in A3 and your range contains Numbers such as 1, 2, 3, 4, 5, 6... No problem 5 will match in you range
On the other hand if your range contains numbers stored as Text (as shown below) 5 won't match in that range
