VLOOKUP function in Excel explained in 60 Seconds

How to use the VLOOKUP function in Excel.
🍐Join my online course on Excel Tables
www.udemy.com/course/tables-i...
🍓Download my free eBook on Excel Macros
eepurl.com/gpT0RD
🍇Check these Books on Excel
xlncad.com/excel-resources/
🍉Read my articles on Excel
xlncad.com/
🍏Playlist for Shorts on Excel
• Short videos on Excel ...
#excelshorts #exceltip #vlookupformula

[@neilhess2518]

Dude. This is PERFECT! Keep making more like this. I love short, simple tutorials like this!!!

[@sweeetsherrie88]

Straight to the point, in simple terms. Thank you

[@danielchigbue7962]

This is short and precise. I couldn't even understand the American explanation after several trials but you made me understand ones... Awesome bro!

[@mateenahmed1522]

Pl

[@MovableNu]

I had to use VLOOKUP for the first time at work yesterday. I was blindly building it across two worksheets, based on instructions I was given. Just following the format.
So THANK YOU for making this fast tutorial showing how the concept works! Now there’s a chance I can do it again! 🔥🔥🔥

[@chimpanzu1199]

May I ask what's your job?

[@r7939]

Omg. My colleague has been trying to teach me this for seven years!! Learnt in 60 seconds 😂

[@edimaelmarin6693]

Bro, you just saved me 💯💯

[@eaglenikhilgaming7433]

Why ? What happened

[@_bhanupratapkheercenter65]

@@eaglenikhilgaming7433 he had a breakup after watching video he got married to his gf n thy lived happily after ever 👏

[@ridhwwan]

I u derstood it WAY better than I understood the one form the MICROSOFT account. Thank you

[@Musicmyzen]

Thank you for making it super easy to understand .😎

[@francinegolden9199]

This is 1 of the reasons why I love Excel

[@VivekKumar-if2ft]

Perfect, short crisp to the point... understood

[@nenadpopadic2781]

Right to the point. Good job

[@rudrauscoikar2529]

Thanks sir

[@zg3671]

This is perfect. Short, sweet and to the point. 👍🎉❤

[@cahaya_IT]

Thanks for your tutorial, may i save and share it ❤

[@Muhammad_Ali9]

I wish I could thank you in Person. You made my life so easy. Thanks a looooooooot

[@RenSayLess]

Short and sweet! THANK YOU!!!

[@Melissa-gw8wy]

So easy to understand. Thank you very much!!!!!

[@NEBE0]

I have a whole list that I have to fill : m^2 of office space for 25 buildings, do I have to do the VLOOKUP procedure every time or?

[@sureshsetti6840]

Most helpful tutorial I've seen..

[@naeemagbani920]

That's why shorts are best at times...

[@IMQ567]

Good, can we look up whole row at a time?????? For example, if i put tony, system should get back with department and salary simultaneosly ??? Anybody can help

[@arjungoyal3351]

Amazing explaination brother.. Lv it

[@yashwanthm4805]

Awesome. Pls make more like this ❤

[@karunakarvemishetty1134]

May i know how to do for department and designation along with salary in one formula that entire staff all department designation and salary should appear

[@svino167]

Thank you for making my job easy👍

[@tranquilo_amigo]

How can I save YT shorts to my playlist from the app

[@rheymanesquibel3061]

Thank you, this very useful tutorial 👍

[@ashleymckillips4807]

Most helpful tutorial I’ve seen!

[@mcwahaab]

Thanks. Would you also do XLOOKUP.

[@en7gmal]

Excellent video. Thank you so much. 🎉🎉🎉

[@nilagv1058]

How to fetch a entire row or column using one key word

[@oikaru]

thank u!! very simple and effective 🤍

[@matchanista2762]

Love this! Now to get this to work across two tables. I’m thinking the fact that they are tables might be the issue?

[@allisona4500]

this was so helpful ty !!!!!!

[@garcialisette707]

great explanation. Thanks

[@ksp_kvt]

Sometimes when we apply the formula result will be shows N/A .
I CAN USE FORMULA WITHOUT ANY ERROR.

[@hiteshsingh276]

I have the same issue, even if I use the ; sign it still doesn't work..I went to advanced and even clicked the box to use separators but still nothing

[@techienomadiso8970]

You are great 👍 thank you so much 💯💯

[@abrarhussainkhan7]

Sir ap ne konsa screen recorder use kia hay. Please 🙏 reply

[@beautywithpscvlog]

Thank u so much sir.. amazingly explained

[@rashidahmad7081]

Super useful tutorial .. wonderful

[@SuperNishin]

Thanks machane ❤️ 👍🏽

[@jerryonline-sn7jk]

thank you

[@SrJackquito]

RUclips algorithm has sent me to this guy…
Now at work i always say..
“In the formulu burr”
🤣👍🏻
But also he has helped me a lot so yeah good info here checks out.

[@dhanasai3492]

Thank you very easy methoed

[@rafas777777777777]

Thank you!

[@breakoutgaffe4027]

Nicely explained

[@hammoudehhasan2436]

index match function is better

[@prodig1389]

Thank you ❤️😊

[@asifshekh9311]

If i changed the look up value it doesn't change the result.

[@sushibhati3392]

Thank you sir ji 🙏💝😊

[@kunaldalvi6135]

ITS VERY HELPFULL...😇

[@Achleshwar_mahadev]

Woww....
thanks to make it easy.

[@BHARATHAJAY1026]

Cool explanation

[@Bharat94]

Very useful 👍

[@shalinichauhan6825]

Great

[@taraksaha3816]

Thanks

[@mehdiG11]

Thanks broooo

[@cookdaddy4949]

Super easy 😄❣️

[@mohdnajibabdulmajid7358]

Very perfect.

[@hanbean22]

we need you 😍

[@rajkumarchavan8457]

Thanks A lot

[@archieaardvark8670]

Great video

[@allprowebdesigns917]

Good work keep it up.

[@anshulgoel7884]

Loved it bro

[@reiwasaru]

BROOO THANK U SO MUCH

[@lalithkishorlalithkishor4768]

Thank u😊

[@jeane4942]

Thank you

[@yashdevpurkar2519]

Excellent

[@KingwaysInternational]

S/5,M/5,L/5= HOW CAN I PLUS THIS FORM

[@parshvashah985]

amazing 🤩

[@Rahulkumar-dg5pu]

Very nice

[@strawberry.milktea]

but why sometimes we need to adjust using F4? when do we know when to use F4?

[@heavenknowsflo]

For example I have Look up value With same name how can I get the total amount of their salary? I tried doing sum + Vlook up pls help

[@BenDieselBasicAutomotive]

😃

[@Zecodesignz]

so it only works for the first column?

[@kirankanwar9048]

Your voice 😍

[@AzmatSyed-st2ov]

Have to subscribe you channel to looks salaries on screen😂

[@ragailunggondaimei3667]

Time efficient

[@pradeepnair4739]

Nice

[@rathoreshailu]

If we also have column of serial number then what should be column number 4 or 5

[@dipalimali940]

Designation department and salary

[@kanhu210]

Sir want some help from you. Multi products are there in one sheet and qty also mentioned. I want the product wise total qty. Pls guide me

[@user-us4ew5uk5d]

Don't need to type false instead type "0"

[@damodaramadan]

Sir how to salary high to low order sir

[@haris6600]

Chettan Malayali aano?

[@shobabharu]

How you take E15?

[@user-ny3ut7bj3u]

I did the same table as yours but still N/A? Can you help? 😢

[@douglaslee7034]

Why false????

[@sanndeepverma5005]

Sir suppose qty is 500000,and 1bag have 1700nos caps so how to populate loose bag with qty in separate column?

[@ExcelBaba]

=mod(500000,1700)

[@arthurdebacker3270]

Wondering why you decide to show VLOOKUP when XLOOKUP exists

[@karthikshinde6739]

Subscribed

[@safarimupe1179]

What is I enter a name that does not exist ? What if there was 2 Tony ?? How to handle

[@skchannelfun]

1st column is not sorted, doesn't it affect the result ??

[@chiranjitghosh9471]

H lookup steps please 🙏

[@umakantmahour4734]

Which windows is this

[@andreiflow5338]

What does False or true do for the last column?

[@Rahulkumar-dg5pu]

Exact match - False or 0 (Exact data value) .... Approx Match - True or 1 (works best when data sorted in ascending order or returns closest relevant data)

[@jnnyccomputer5326]

Easy form sumif 😂

[@chaitravikoli16]

Formula is not working its showing N/A

[@maneeshahettiarachchi1528]

❤

[@ishitatyagi3446]

I feel bad for Tony tho