Thanks so much for the help! It worked out well and was exactly what I needed. Is there a way I can hide all the non-matched emails? I don't want to have all the cells with #N/A visible? I know I can do it manually, but if there is a formula, it would be a lot faster.