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?

Open Microsoft Excel and start with worksheet.

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

How to use LOOKUP Function in Excel?

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

How to use LOOKUP Function in Excel?

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

How to use LOOKUP Function in Excel?

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

How to use LOOKUP Function in Excel?

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

How to use LOOKUP Function in Excel?

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

How to use LOOKUP Function in Excel?
Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Hey, wait!Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.