BMO Financial Group interview question

excel problem: v lookup