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/...
🍓Download my free eBook on Excel Macros
eepurl.com/gpT0RD
🍇Check these Books on Excel
xlncad.com/exc...
🍉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!!!

[@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

[@sweeetsherrie88]

Straight to the point, in simple terms. Thank you

[@BenDieselBasicAutomotive]

😃

[@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?

[@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

[@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

[@douglaslee7034]

Why false????

[@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

[@asifshekh9311]

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

[@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?

[@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

[@hammoudehhasan2436]

index match function is better

[@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 👏

[@nourakhater800]

Finally I did it right 🎉🎉🎉🎉🎉thank you very much 👏👏👏👏

[@nilagv1058]

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

[@cahaya_IT]

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

[@KingwaysInternational]

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

[@arthurdebacker3270]

Wondering why you decide to show VLOOKUP when XLOOKUP exists

[@maryogie1941]

I don't think I would want to work at this company. Salaries too low. Lol

[@safarimupe1179]

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

[@abrarhussainkhan7]

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

[@strawberry.milktea]

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

[@12k-y4q]

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

[@AzmatSyed-st2ov]

Have to subscribe you channel to looks salaries on screen😂

[@Musicmyzen]

Thank you for making it super easy to understand .😎

[@rudrauscoikar2529]

Thanks sir

[@BandelVmart]

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

[@naeemagbani920]

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

[@chaitravikoli16]

Formula is not working its showing N/A

[@damodaramadan]

Sir how to salary high to low order sir

[@Zecodesignz]

so it only works for the first column?

[@nenadpopadic2781]

Right to the point. Good job

[@arjungoyal3351]

Amazing explaination brother.. Lv it

[@mcwahaab]

Thanks. Would you also do XLOOKUP.

[@VivekKumar-if2ft]

Perfect, short crisp to the point... understood

[@ishitatyagi3446]

I feel bad for Tony tho

[@Rajib9912]

what happet when i select true

[@haris6600]

Chettan Malayali aano?

[@jnnyccomputer5326]

Easy form sumif 😂

[@tyronewalker5764]

Eye opening, Sir.😊

[@vikv4884]

Its done by a malyali...

[@shobabharu]

How you take E15?

[@shalinichauhan6825]

Great

[@umakantmahour4734]

Which windows is this

[@mdamirali1938]

Bro you just save me ❤❤❤

[@ridhwwan]

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

[@yashwanthm4805]

Awesome. Pls make more like this ❤

[@Funnnyvideo57]

Wait... Why false?

[@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

[@harikrishnanjavahar6718]

Why not xlookup

[@hanbean22]

we need you 😍

[@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?

[@khansamia3888]

Thanks sir

[@sureshsetti6840]

Most helpful tutorial I've seen..

[@riddhijain3218]

Blur

[@mehdiG11]

Thanks broooo

[@jerryonline-sn7jk]

thank you

[@jagadeeshat6963]

Simble

[@suryach3836]

If I want to know how many people are getting more than 20000 salary, what is the formula

[@ExcelBaba]

=countif(F1:F13,">20000")

[@rathoreshailu]

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

[@pradeepnair4739]

Nice

[@Muhammad_Ali9]

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

[@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)

[@MandixYaborgi]

Amazing

[@sharank.officialchannel5428]

👌

[@dipalimali940]

Designation department and salary

[@rockydas]

Why not using xlookup instead of vlookup?

[@beautywithpscvlog]

Thank u so much sir.. amazingly explained

[@maneeshahettiarachchi1528]

❤

[@dipalimali940]

But i need all three

[@AjayAnandXLnCAD]

Please check this video.
th-cam.com/video/q0XfqK_TXFA/w-d-xo.html

[@en7gmal]

Excellent video. Thank you so much. 🎉🎉🎉

[@MaryOlayemi-cv3nw]

👏🏻👏🏻👏🏻

[@taraksaha3816]

Thanks

[@Melissa-gw8wy]

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

[@SrJackquito]

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

[@preetipivhal9577]

You don't mention department to salary

[@skchannelfun]

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

[@zg3671]

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

[@RenSayLess]

Short and sweet! THANK YOU!!!

[@francinegolden9199]

This is 1 of the reasons why I love Excel

[@ashleymckillips4807]

Most helpful tutorial I’ve seen!

[@garcialisette707]

great explanation. Thanks

[@Achleshwar_mahadev]

Woww....
thanks to make it easy.

[@allisona4500]

this was so helpful ty !!!!!!

[@chiranjitghosh9471]

H lookup steps please 🙏

[@svino167]

Thank you for making my job easy👍

[@dhanasai3492]

Thank you very easy methoed

[@rashidahmad7081]

Super useful tutorial .. wonderful

[@engkarrar2582]

Thanks alot

[@kunaldalvi6135]

ITS VERY HELPFULL...😇

[@sushibhati3392]

Thank you sir ji 🙏💝😊

[@techienomadiso8970]

You are great 👍 thank you so much 💯💯

[@uzziesoul]

Thanks sir

[@archieaardvark8670]

Great video

[@lalithkishorlalithkishor4768]

Thank u😊

[@khanyambono5488]

Thank you

[@Theachieverrko]

Xlookup

[@rafas777777777777]

Thank you!

[@jeane4942]

Thank you