BMO Financial Group Interview Question

excel problem: v lookup