In this blog, We have discussed the different important topics of Excel and many more...
What is the Lookup Function?
• A Lookup function in Excel is used to search a value in a table and return the corresponding result from another column or row.
Simple Definition: A Lookup function finds data in a table and returns the related value.
Lookup Function
• Basic lookup function (less commonly used).
• value either one row or one column range or from array you specify.
Syntax:
=LOOKUP(Lookup value, array)
Example:
• =LOOKUP(102, B2:B6, D2:D6)
• corresponding value from another column.
-------------------------------------------------------------------------------------------------------------
Types of Lookup Function
1. VLOOKUP (Vertical Lookup)
• value in the leftmost column of table and return value of same raw from column you specify.
2. HLOOKUP (Horizontal Lookup)
• value in the top raw of table or array of values and returns the value in same column from a raw you specify
---------------------------------------------------------------------------------------------------------------
VLOOKUP (Vertical Lookup)
• Searches data vertically (column-wise).
• To perform a vertical lookup, you will have to make use of the VLOOKUP function.
Practical Steps for VLOOKUP function
• Prepare your data in table format.
• Select the cell where you want the result.
Formula:
• VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
• Press Enter.
here,
• lookup_value gives the value to be looked out for
• table_index is the range from where the data is to be taken
• col_index_num specifies the column from which you want to fetch the value
• range_lookup is a logical value
• i.e TRUE or FALSE
(TRUE will find the closest match;
FALSE checks for exact match)
--------------------------------------------------------------------------------------------------------------
VLOOKUP Example
• Find marks of ID = 102
• Formula:
• =VLOOKUP(102, A2:C4, 3, FALSE)
• Result: 75
---------------------------------------------------------------------------------------------------------------
Another VLOOKUP Example
HLOOKUP (Horizontal Lookup)
• Searches data horizontally (row-wise).
• To perform a horizontal lookup, you will have to make use of the HLOOKUP function.
Practical Steps for HLOOKUP function
• Prepare your data in table format.
• Select the cell where you want the result.
Formula:
• SYNTAX: HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
• Press Enter.
here,
• lookup_value gives the value to be looked out for
• table_index is the range from where the data is to be taken
• row_index_num specifies the row from which you want to fetch the value
• range_lookup is a logical value
• i.e. TRUE or FALSE
(TRUE will find the closest match;
FALSE checks for the exact match)
---------------------------------------------------------------------------------------------------------------
HLOOKUP Example
Find name of ID = 102
• Formula:
• =HLOOKUP(102, A1:C2, 2, FALSE)
• Result: Riya
--------------------------------------------------------------------------------------------------------------
Another HLOOKUP Example
LOOKUP Advantage
• Saves time in searching data
• Reduces manual work
• Useful for student marks, reports, databases
---------------------------------------------------------------------------------------------------------------
Or follow my blog from the below link
Also, Join my Telegram channel with the below link
Also, join my Whatsapp group with the below link
0 Comments