## What is a lookup formula?

Lookup functions in Excel are used for looking through a single column or row to find a particular value from the same place in a second column or row. This often takes place when there are multiple worksheets within a workbook or a large amount of data in a worksheet.

**How do you use lookup?**

- In the Formula Bar, type =VLOOKUP().
- In the parentheses, enter your lookup value, followed by a comma.
- Enter your table array or lookup table, the range of data you want to search, and a comma: (H2,B3:F25,
- Enter column index number.
- Enter the range lookup value, either TRUE or FALSE.

### What is VLOOKUP used for?

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.

**What is Col_index_num?**

The col_index_num is the column of data that contains the answer that you want. If your table is set up as: column 1 – Student ID Number, column 2 – Student Names, column 3 – Grades and you inputted a Student ID Number and you want to retrieve the grade that was received for that person, the col_index_num would be 3.

## Why lookup is used in Excel?

The Excel LOOKUP function performs an approximate match lookup in a one-column or one-row range, and returns the corresponding value from another one-column or one-row range. LOOKUP’s default behavior makes it useful for solving certain problems in Excel. A value in the result vector.

**What is lookup value in VLOOKUP?**

The value you want to look up, also called the lookup value. The range where the lookup value is located. Remember that the lookup value should always be in the first column in the range for VLOOKUP to work correctly. For example, if your lookup value is in cell C2 then your range should start with C.

### What is a lookup value?

A value that LOOKUP searches for in an array. The lookup_value argument can be a number, text, a logical value, or a name or reference that refers to a value. If LOOKUP can’t find the value of lookup_value, it uses the largest value in the array that is less than or equal to lookup_value.

**What is the difference between lookup and VLOOKUP?**

The main difference between VLOOKUP and LOOKUP functions is the VLOOKUP is limited to vertical lookups only and the LOOKUP function has cross functionality which means that it can perform both vertical lookups and horizontal lookups.

## What is table_array?

A table array is one of the arguments used in Excel’s lookup functions, such as VLOOKUP and HLOOKUP. The LOOKUP functions search the table array to find specific information. For VLOOKUP (vertical lookup), the table_array must contain at least two columns of data.

**What is a lookup vector?**

The vector form of LOOKUP looks in a one-row or one-column range (known as a vector) for a value and returns a value from the same position in a second one-row or one-column range.