MetLife Interview Question

Explain when you use vlookup in excel