In addition to your point re: Sheet2... one of your Match functions was also using a match_type of 1 (TRUE) rather than 0 (FALSE - exact match) which would have caused issues...