Your first criteria '2025 Average Rates - Data'!A46, as writen, is not a criteria, just a cell reference. Try writing instead "="&'2025 Average Rates - Data'!A46 to test for the equality.