Forum Discussion
stanwykosky
Oct 20, 2025Copper Contributor
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?
No RepliesBe the first to reply