Wells Fargo Interview Question

Write a VLOOKUP formula based on the given tables and multiple conditions.