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

Share this & earn $10
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
excel lookup functionlookup function in excellookup function on excel

Web Design: How to Get Started in 2019 (+ Resources)

Web Design: How to Get Started in 2019 (+ Resources)

Split (2017) - I Think You Have the Wrong Car Scene (1/10) | Movieclips

Split (2017) - I Think You Have the Wrong Car Scene (1/10) | Movieclips

TYPES of RELATIVES ... | #RolePlay #Sketch #ShrutiArjunAnand #Anaysa #MyMissAnand

TYPES of RELATIVES ... | #RolePlay #Sketch #ShrutiArjunAnand #Anaysa #MyMissAnand

Kev's Feelings In The Past Few Days~ | Jet_Raytm

Kev's Feelings In The Past Few Days~ | Jet_Raytm

Should Teenagers Be Dieting?

Should Teenagers Be Dieting?

Auf Wiedersehen

Auf Wiedersehen

Aamir - Why Should I Stay? (Prod. Aamir)

Aamir - Why Should I Stay? (Prod. Aamir)

Mother-In-Law Insults Wife, What Son Decides To Do About It Is So Sad | Dhar Mann

Mother-In-Law Insults Wife, What Son Decides To Do About It Is So Sad | Dhar Mann

Typically

Typically

Most commonly broken bones in the Human body |ย Kenhub

Most commonly broken bones in the Human body |ย Kenhub

VOLLEYBALL COACH REACTS TO HAIKYU S1 E13 - Rival

VOLLEYBALL COACH REACTS TO HAIKYU S1 E13 - Rival

Via - Claudio Baglioni

Via - Claudio Baglioni

15 Kinds Of Passengers That Flight Attendants Hate

15 Kinds Of Passengers That Flight Attendants Hate

The Cranberries - Free To Decide

The Cranberries - Free To Decide

Two softer cerumens and one particularly hard cerumen

Two softer cerumens and one particularly hard cerumen

Learning English for Beginners: My top tips

Learning English for Beginners: My top tips

เคธเคฌเคธเฅ‡ เค…เคšเฅเค›เคพ เค”เคฐ เคธเคธเฅเคคเคพ เคŸเคฐเฅเคฎ เค‡เคจเฅเคธเฅเคฐเฅ‡เค‚เคธ  || ICICI Prudential I Protect Plan Term Plan || Term Insurance

เคธเคฌเคธเฅ‡ เค…เคšเฅเค›เคพ เค”เคฐ เคธเคธเฅเคคเคพ เคŸเคฐเฅเคฎ เค‡เคจเฅเคธเฅเคฐเฅ‡เค‚เคธ || ICICI Prudential I Protect Plan Term Plan || Term Insurance

Stress Management Is The Key To The Bounce Back | Wes Watson

Stress Management Is The Key To The Bounce Back | Wes Watson

Real Fire Truck Driving Simulator 2020 - Fireman's Daily Job Game - Android Gameplay

Real Fire Truck Driving Simulator 2020 - Fireman's Daily Job Game - Android Gameplay

เดฎเตเดŸเตเดŸเดพเตป เดจเดฟเตฝเด•เตเด•เดฃเตเดŸ ๐Ÿ˜ฒ| Biggest Animal in the world Malayalam | Freshyan | Largest Animals in the world

เดฎเตเดŸเตเดŸเดพเตป เดจเดฟเตฝเด•เตเด•เดฃเตเดŸ ๐Ÿ˜ฒ| Biggest Animal in the world Malayalam | Freshyan | Largest Animals in the world

Mojotone '72 Wide Range Humbucker Demo and Comparison

Mojotone '72 Wide Range Humbucker Demo and Comparison

Generating the Proton Gradient: The Electron Transport Chain (Cellular Energetics #2)

Generating the Proton Gradient: The Electron Transport Chain (Cellular Energetics #2)

First of all / DISTANCE

First of all / DISTANCE

How To Wear Brogue Dress Shoe Featuring Beckett Simonon/How To Style Brogues

How To Wear Brogue Dress Shoe Featuring Beckett Simonon/How To Style Brogues

[English Vocabulary] Insufficient | Meaning and Pronunciation

[English Vocabulary] Insufficient | Meaning and Pronunciation

Why Iphone is Costly in India | Why iPhone is Expensive in India

Why Iphone is Costly in India | Why iPhone is Expensive in India

(Even More) Laura Perrins

(Even More) Laura Perrins

I Don't Have Anything ~ John Thornton (Richard Armitage)

I Don't Have Anything ~ John Thornton (Richard Armitage)

Best Hybrid Laptops 2020: top laptop-tablet hybrids

Best Hybrid Laptops 2020: top laptop-tablet hybrids

NEW Rolls-Royce Ghost: Road Review | Carfection 4K

NEW Rolls-Royce Ghost: Road Review | Carfection 4K

The Score - Legend (Audio)

The Score - Legend (Audio)

Beautiful

Beautiful

Haven't vs don't have || have not & do not have in english grammar || learn English

Haven't vs don't have || have not & do not have in english grammar || learn English

Lewis 03x02 The Quality Of Mercy

Lewis 03x02 The Quality Of Mercy

Taylor's Date Left Her Heartbroken

Taylor's Date Left Her Heartbroken

Roger Federer - Top 10 Identical Shots โ— Part 2

Roger Federer - Top 10 Identical Shots โ— Part 2

The Last Few Words Of Prophet Muhammed ๏ทบ แดดแดฐ ll Emotional! ll Mokhtar Maghraoui [RIS]

The Last Few Words Of Prophet Muhammed ๏ทบ แดดแดฐ ll Emotional! ll Mokhtar Maghraoui [RIS]

GERMAN NAMES That Also Mean Other Things

GERMAN NAMES That Also Mean Other Things

When you get peer pressured into playing Phasmophobia

When you get peer pressured into playing Phasmophobia

Wintertime - All The Time 2 (Official Music Video)

Wintertime - All The Time 2 (Official Music Video)

10-Minute Feel-Good Cardio Workout and Meditation to Say Goodbye to Stress

10-Minute Feel-Good Cardio Workout and Meditation to Say Goodbye to Stress

A. Wise - โ€œLost Car Keys"

A. Wise - โ€œLost Car Keys"

How To Build The Most Modern Underground Swimming Pools with Underground House

How To Build The Most Modern Underground Swimming Pools with Underground House

Chase Bryant - Little Bit of You (Audio)

Chase Bryant - Little Bit of You (Audio)

The Golgi apparatus: From structure to function

The Golgi apparatus: From structure to function

The Images of Architects edited by Valerio Olgiati

The Images of Architects edited by Valerio Olgiati

Wholesome Celebrities

Wholesome Celebrities

YOUNOW SINGING | SHE CRIED WHEN I SANG THIS SONG! [BEST REACTIONS] [2020]

YOUNOW SINGING | SHE CRIED WHEN I SANG THIS SONG! [BEST REACTIONS] [2020]

Yaar Graribaaz - Dilpreet Dhillon | Karan Aujla | Shree Brar | Desi Crew | Latest Punjabi Songs 2018

Yaar Graribaaz - Dilpreet Dhillon | Karan Aujla | Shree Brar | Desi Crew | Latest Punjabi Songs 2018