VLOOKUP/HLOOKUP & LOOKUP formula with Example

VLOOKUP is a very powerful function to join 2 tables and find reference values from another table.

Correct use of the same can help in quickly achieving the task.

In this various LOOKUP functions are explained in very detail with various examples.

What is VLOOKUP:

VLOOKUP is used to join
two tables, where you want to get reference data from another table.

VLOOKUP - Basic Example (Exact Match)

VLOOKUP Formula is =VLOOKUP(What to find, where to find, which column, type of match). If there is no error, it gives #N/A error, using the IFNA function such error can be handled.

Also references needs to be locked, so that VLOOKUP can be copied correctly.

VLOOKUP - Advanced Example

- Using Function Dialogue box, Exact Match, Named Range, From Different worksheet VLOOKUP can be used to find Exact Match or Approximate(closest match). Also using Name Range is another way to lock the range.

VLOOKUP – Approximate Match Example

VLOOKUP with Type = 1 is used to find an approximate match. This helps in finding if the data is in some range or nearest match.

LOOKUP – Example

LOOKUP is used to find Horizontally or Vertically in the selected column. Also using LOOKUP, left lookup is possible, which is not possible in VLOOKUP otherwise.