Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelLOOKUP Function in Excel

# LOOKUP Function in Excel

In this post, youâ€™ll learn about the LOOKUP function in excel and how to use it in your excel spreadsheet.

## LOOKUP Function 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.

### Syntax:

`=LOOKUP(lookup_value,lookup_vector,[result_vector])`

### Argument:

• Lookup_value- the value to search for
• Lookup_vector-the one row ,or one column range to search.
• Result_vector-[optional]the onerow ,or one column range of results.

## How to use LOOKUP Function in Excel?

STEP 1: Here, we have entered some income with fixed tax. Using LOOKUP function we can find approximately the tax for relatable income.

STEP 2: Here we have entered the Income 100. Using syntax we can find the tax of the given value.

STEP 3: Place your cursor in the cell in which the value to be find. enter the following syntax =lookup(.

STEP 4: Here the first cell is selected and automatically the cell name is entered as A2.

STEP 5: The array is selected and entered followed by the syntax.

STEP 6 : By giving enter the tax value of the given income will be resulted.

Share:

### You May Also Like

#### SKEW.P Function in Excel

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...

#### SKEW Function in Excel

In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...

#### RANK.EQ Function in Excel

In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
• Excel
• November 23, 2021