Forum Discussion

stanwykosky's avatar
stanwykosky
Copper Contributor
Oct 20, 2025

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

Resources