Scotiabank interview question

Vlookup, Macro