Question: What is VLOOKUP in Excel example?

The VLOOKUP function always looks up a value in the leftmost column of a table and returns the corresponding value from a column to the right. 1. For example, the VLOOKUP function below looks up the first name and returns the last name. No worries, you can use INDEX and MATCH in Excel to perform a left lookup.

What is a VLOOKUP in Excel?

VLOOKUP stands for Vertical Lookup. It is a function that makes Excel search for a certain value in a column (the so called table array), in order to return a value from a different column in the same row.

Reach out

Find us at the office

Vandervelde- Benatar street no. 22, 41683 Belfast, United Kingdom Northern Ireland

Give us a ring

Tristian Espalin
+61 275 909 392
Mon - Fri, 7:00-15:00

Reach out