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.
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.
