Pergunta de entrevista da empresa Hotwire

Unexpected: How would you write a vlookup in Excel? An If statement?