I dont think that macro is required. Please have a look at the attached filevalues-missing-in-list-1-that-exists-i-list-21.xls