MetLife interview question

Explain when you use vlookup in excel