Pergunta de entrevista da empresa Prudential

How does a VLOOKUP function work in excel?