> .. Thanks but still returning the #VALUE! error
Formula should work fine, that just means your source data in Export's col M contains at least 1 instance of #VALUE!
Use AutoFilter on col M to locate all of these cells with #VALUE!, clear them with the DELETE key