Genpact interview question

Lookup,VBA, Data cleaning and Macros