# Excel LOOKUP Function | Formula | How to use LOOKUP in Excel?

WallStreetMojo
Published at : 07 Feb 2021
12489 views
44
8

In this video on Excel LOOKUP Function, we are going to learn how to use LOOKUP in excel sheet using LOOKUP Excel Function.

๐๐๐๐๐๐ ๐๐ฎ๐ง๐๐ญ๐ข๐จ๐ง ๐ข๐ง ๐๐ฑ๐๐๐ฅ
------------------------------------------------

The function LOOKUP in Excel returns a value from range of values (a row or column) or an array. It's an integrated feature in Excel.

๐๐๐๐๐๐ ๐๐ฑ๐๐๐ฅ ๐๐จ๐ซ๐ฆ๐ฎ๐ฅ๐
--------------------------------------------

Below is the formula of LOOKUP Function

= LOOKUP (lookup_value, lookup_vector, [result_vector])

๐๐ซ๐ ๐ฎ๐ฆ๐๐ง๐ญ๐ฌ
----------------------------

Value โ The search value.

Lookup vector โ A row or range of columns to search for a value. In ascending order, the vector should be sorted.

Result vector โ [ optional ] A row or column range that matches the lookup vector and includes the desired output.

๐๐ฉ๐ฉ๐ฅ๐ข๐๐๐ญ๐ข๐จ๐ง๐ฌ ๐จ๐ ๐๐๐๐๐๐ ๐๐ฎ๐ง๐๐ญ๐ข๐จ๐ง ๐ข๐ง ๐๐ฑ๐๐๐ฅ
--------------------------------------------------------------------------

#1 - Extract an item's price using its ID.
#2 - Find the book's location in the library
#3 - Get the last month or year transaction
#4 - Check an item's recent price
#5 - Find the last row in numeric/text data
#6 - Get the last transaction's date

To know more about ๐๐๐๐๐๐ ๐๐ฑ๐๐๐ฅ ๐๐ฎ๐ง๐๐ญ๐ข๐จ๐ง, you can go to this ๐ฅ๐ข๐ง๐ค ๐ก๐๐ซ๐:- https://www.wallstreetmojo.com/lookup-excel-function/

Subscribe to our channel to get new updated videos. Click the button above to subscribe or click on the link below to subscribe - https://www.youtube.com/channel/UChlNXSK2tC9SJ2Fhhb2kOUw?sub_confirmation=1