StartUs Insights Interview Question

How does VLOOKUP work in Excel?