How to VLOOKUP in 30 seconds

📚 The Excelerator Course is perfect for beginner to intermediate level Excel users:
www.miss-excel.com/courses/th...
📈 The Advanced XL Dashboards Bundle is perfect for analysts who work in finance and accounting, business intelligence, research and information technology.
exceldashboards.thinkific.com...
💹 Save when you get Excel for Microsoft 365 (PC or Mac):
click.linksynergy.com/link?id...
📊 Simple Sheets - 100+ Templates for Conquering Excel:
www.simplesheets.co/a/2147504...
🏫 Excel Academy by MyExcelOnline:
myexcelonline.refr.cc/cheatsheets
👕 Excel Merch by CheatSheets:
my-store-11484182.creator-spr...
🎁 Bonus Excel Content by CheatSheets:
linktr.ee/CheatSheets
🌎 Where you can follow us ⬇️
Instagram: / thecheatsheets
TikTok: / cheatsheets
Twitter: / the_cheatsheets
Linkedln: / cheatsheets
Facebook: / thecheatsheets
Patreon: www.patreon.com/cheatsheets?f...
Note: This description contains affiliate likes, which means that at no additional cost to you, we may receive a small commission for each purchase that you make using our affiliate links. This helps support our channel and allows us to continue creating valuable content for viewers like you.

[@katiebanks7460]

I started watching a 30 minute tutorial and was like a dummy thinking whaaaaat. Left after 10 minutes, watched your 30 second video...i totally got it and used it on various reports. Thank you!!

[@jasonaalab]

Do you know how to select the entire table without dragging it with the mouse?

[@saras1663]

@@jasonaalab Hold Shift + arrow keys to select one cell at a time. CTRL + SHFT +arrow keys (down arrow key) to select the data....in this video it would be CTRL + SHFT + right arrow then down arrow key

[@jahimuddin2306]

I spent the entire video looking at the names.

[@madhumithaa8523]

brehhhhhhhh

[@theondrahamilton9988]

Usain Flash 😂

[@migamafiri6473]

@@theondrahamilton9988Phil MickelDAD

[@anujoseph_10]

That's why you won't be getting a job😂

[@jahimuddin2306]

@@anujoseph_10, I have a job.

[@ashielovestolearn]

I looked up so many videos and it didn't work for me, but your tutorial worked as soon as I got the hang of it🥺 thank you!

[@sarahhawkins5339]

Legend! I have looked this up so many times today and couldn’t figure it out, but I just tried your vid and it worked perfectly the first time ! Thank you!😊

[@francescamendoza336]

This was really helpful, thank you!

[@CheatSheets]

Happy to help! 💚

[@seekhokuchbhi7876]

See the advance than Vlookup :kzbin.info/www/bejne/aXq1fZ2pZdZjbMUsi=p4S6i3Q994Yeui9E

[@Mystic5683]

Why not use the built-in features of Excel by using structured tables and forget about the old fashion cell referencing using column and row references? Nobody uses old cell referencing since structured tables were introduced in 2007! V-lookup is a function that still exists, but it requires the look up column to be in the left-most column of your range. Since 2007, most people use the "INDEX + MATCH" functions together with structured table referencing. Look it up, it is much simpler and easy to troubleshoot, and if you ever change the structure of your table, the formulae are updated dynamically. In your example, if the ID column is not located on the far left ... OR ... If another column is inserted between the ID and Name columns ... OR ... if your list grows (another line added), then your vlookup formula has to be updated. With structured tables (table name = list), the formula would be =INDEX(list[Name],MATCH(B3,list[ID],0))... And never has to be changed.

[@mkrishna2593]

Great info. Do you have any good resource to master structured tables?

[@Sickofadgendas]

Very anxious to master excel. please share

[@sheeplestrafer9413]

Comments like these are why I always skim the comments section. Sift through enough overburden, and you will often find gold. Thank you, for the information.

[@phandongexcel]

Tôi thích nội dung này

[@jh.5687]

Those names satisfy me to Live 😂. It's a life changing! 😂😂😂

[@gregoryking4796]

XLOOKUP for the W tho

[@nirmalrana9439]

Nice.... awesome and short

[@CheatSheets]

Glad you enjoyed this one! Let us know if you ever have any questions or video requests 💚

[@Anas_fazil]

You know shit about to go down When you see Christian Ronaldo top of the table

[@motivation_m00d]

Great and helpful 😊

[@stevew3947]

"Shake Oneil" 😂 great example hilarious name

[@CheatSheets]

Happy to hear the names gave you a laugh 😂

[@hydgurl77]

Yessssss I'm one of them 🫣 Love your videos..... very helpful! Thank you! Only request...please do something about the music in the background... it's loud and distracting. Please reduse the volume. Your new subscriber 🙂

[@user-pn3bw6zp8k]

95% of excel users don’t require to use vlookup

[@CheatSheets]

VLOOKUP is a super powerful function! However, if you have access to the XLOOKUP function, we definitely recommend using that instead 😁

[@jhonnmaicol6692]

Awesome, thanks 👍

[@indunair4105]

Soooo easyyyyyyyyyyyy.. Thanks session a ton

[@CheatSheets]

Glad you liked this tip! Let us know if you ever have any questions or requests 💚

[@3kings2625]

Great tutorials.👌👍

[@CheatSheets]

Happy to hear you’re enjoying them! 😁

[@ronroca4387]

You saved the day

[@mj1reyes]

Thank you for this

[@robertodhiambo6148]

Thanks a lot sir

[@Haudidau]

Great video, very good pixel quality! Unfortunately it's useless for someone trying to figure out how to use vlookup

[@gashu2954]

U can use Name Range like Vtable instead of selecting data every now n then.

[@lurk-]

These names are hilarious 😂

[@pratapkeshavpawar9689]

🕉️🇮🇳🙏Res Excel Master 🙏 this vedio being really verrrrrry helpfull to watch how to aplly VLOOK FUNCTION,precisely the best in addition to that those images of VLOOK FUNCTION awesome, expecting more data how to go through it with no error in formulas guide please 🙏 Just now how you indicate formula VLOOK FUNCTION images understood table array,column F4 please Zoom on data clearly seen & understand s .001 in cell but 1 show for 001 ? Please how 001 editing in cell 1 appears,but I learnt and followed. Thanking you पी के पंवार

[@emalynudtujan8531]

Thanks for this❤

[@CheatSheets]

You're so welcome! 💚

[@mahmoodalmahmood7014]

Thanks

[@keisycruz3958]

wow, super helpful

[@yourplaylistmusic.]

How to press "F4" on excel in macbook air? Is it shift + 4?

[@manjulakarthik2157]

insted of I'd no type, create a list ( data validation - settings - list) no need of type each and every time

[@sreejithksmail]

why i never thought about it before?.....

[@cmondragon0911]

I am following the instructions and getting #N/A's.

[@femto-dude]

Yeah me too 😢

[@vonsalamera3766]

Is it functionable also in Spreadsheet?

[@scarletfoxfrostnovember3407]

Is there a source file to try it myself? This function is very new to me!!!

[@kuldeepmaurya9673]

What is the Shortcut for selection of whole data

[@kenlingatong5913]

up. I want to know also

[@choxa_9]

cristiano ronaldo......is even in excel..true goat

[@pocketsdsquirrel3207]

Xlookup is the future

[@saifulla0717]

How to copy that data to my Excel sheet it's possible to copy your KZbin data in my exel sheet

[@gwenjackson3068]

Can someone explain to me why "true" is apx?

[@martysherlock]

You get n/a in the result cell if the id lookup value cell is empty,i.e no value is entered

[@silviamtz8961]

I don't see what has been changed and I've been looking. Can someone explain please?

[@Paulo-om4wv]

Are you one of them durfa turka?

[@Bashar._.1612]

What is the ,2, ?

[@MyMomHadMe]

What happens if 19 is in there twice?

[@8Jallin]

I need this in Python how do I ask chatgpt

[@erick2051]

hey, where did you get the 95% statistic source from?

[@bobgreenfield9158]

43% of all statistics are made up!

[@user-bp6oh3py5d]

Do u have long video for view lookup?

[@CheatSheets]

Do you mean the LOOKUP function? If so, then yes, we do have a video on this topic! 🙂

[@lalitjadoun8800]

Hi, in case if i have mentioned the id and name me last of the sheet do i need to count the number. What is the solution for that

[@CheatSheets]

We apologize, we’re not sure we fully understand your problem. Would you mind clarifying?

[@Absta86]

What if you want to look up an employee establishment and check is anyone is hired under the same number or check if numbers are missing etc? Can you show how to do that?

[@umrbekmatrasulov4141]

then it shows #N/A

[@arcangeld]

When you only have a match, every problem looks like an indec

[@katielarsen2630]

Can this return more than one answer, for example everything in the table (C column) that's above a certain value (in the B column)?

[@_sonicfive]

Use a filter() for that

[@valerioharvey7289]

Christian Ronaldo is the most american thing I've seen today

[@tabularasa421]

Index match when you need more flexibility

[@thomass1891]

I’ll still forget it 😂

[@candicetomlin5612]

How do you use vlookup if you want a value on sheet 1 if found on sheet 2 to say a word like "approved"?

[@Aeesha_ke]

Try the if function instead

[@deaniart]

0:10

[@rocodux]

❤❤❤❤❤ by 100000

[@danielminnear9620]

Still have no idea what vlookup can do that xlookup can’t.

[@randomxyz1160]

what are the differences between vlookup and filter function ?

[@CheatSheets]

VLOOKUP fetches specific values based on a search key, while FILTER extracts entire rows based on specific criteria 😊 Let us know if you ever have any other Excel questions or video requests 😁

[@scrumbaker]

Gee thanks for reposting what we learned in 3rd grade. Go FY

[@user-je5fb5gy8q]

how did you highlight the whole table like that?

[@iamtheman4416]

Ctrl + A after selecting any cell in the table

[@riggyB]

You can put 0 in place of FALSE as well.

[@CheatSheets]

Definitely! We prefer using FALSE as it’s a bit more intuitive 😊

[@softwaredynamicsolutions]

👍👍👍

[@mrgameplays7551]

What did that 2 mean? The Column number was not 2! Please explain

[@CheatSheets]

Yes! 2 represents the column number of the result column in relation to the table_array selected in the second portion of the syntax 🙂

[@alexaltego]

the names 😂😂

[@MrBraiden]

Names are so funny

[@tintinfan007]

Forget vlookup and hlookup...do excel users even know how to use logic functions such as AND & OR. and IF loops

[@CheatSheets]

All of these are super important to learn! We have videos on each of these topics 😁

[@tintinfan007]

@@CheatSheets I know...I am already an expert with IF, AND and OR

[@casr01]

​@@tintinfan007 No BUT's?

[@tintinfan007]

@@casr01 why don't you use it if you like it so much

[@The_Python_Turtle]

If you guys are still struggling with this vlookup. I have also posted a video on my channel for this as I was suprised some people at work didnt know it. Link is here => kzbin.infoZrCPOYnxuSg?feature=share

[@trapbeats5844]

Bad loud music

[@StuninRub]

If you are still using and teaching Vlookup in 2023, you clearly have no idea what you are doing.

[@CDABXXX]

Why ?

[@StuninRub]

@@CDABXXX There are so many better look up functions that do not have the limitations of vlookup. The only people who use vlookup are those who learned excel back in the late 90s and never bothered to educate themselves further.

[@mariannetvofficial9040]

😂😂😂

[@jomargarbin6262]

Index and match combination. Much better and quick in calculation

[@anantaR]

@@StuninRub maybe u should make tutor video for that

[@marshaletim5862]

Mine is showing #N/A

[@CheatSheets]

Be sure to follow the steps exactly as shown in this video! Let us know if you’re still having trouble 😊

[@apips.studios7677]

leebroff jamess lol

[@CheatSheets]

hehe 🤭

[@DarkSide-mx3id]

How to hide error value IF no need to key in the data id... this value -> #N/A

[@DarkSide-mx3id]

Anyone know please sharing ,,, i do some template to find the name and auto show the badge id but if the column no name required , i want it empty without any error value like this - #N/A , its look not nice 😅

[@jehad1582]

And u used vlookup with out list ?? Lol use list for id they will be very easy to u❤

[@MS-zp7bt]

Apologies but not helpful. Not enough time to read what information is being requested along with instructions. I'd probably do better with a longer version of instructions - but that's just me.

[@jdijkstra8115]

Or you know... Use cntrl F?

[@hospitaladministrator3359]

Woossshhh

[@fyhdhgg]

cant always do that when u have 2 sheets u working from

[@ahmedmaash7413]

doesnt work on big files with 2 excel sheets

[@The_arab_cat]

no problem doing it except that MY TEACHER WANTS IN IN SPECIFIC TYPES OF LOOKUPS FOR SOME STUPID AHH REASON

[@louvierejacques]

Quiet, grown ups are talking.

[@Reekay47]

Lol Floyd Juneweather.

[@septea7032]

Christian Ronaldo okay Lebroff james i dont care But whyyy Federerer

[@_sonicfive]

There are far better functions like filter()

[@cooptexissrmdu4697]

FOR BULK DATA IT IS NOT WORKING

[@CheatSheets]

We’d be happy to help - would you mind explaining where you’re running into an issue?

[@mohamedmehraz3537]

Hilarious 😂

[@CheatSheets]

Glad you enjoyed this! 😊

[@sassouusasoo3607]

🙄🙄🥱

[@marcusfranconium3392]

Most people use X lookup

[@CheatSheets]

We 💚 XLOOKUP! However, it is not available on older versions of Excel. So, you may run into errors when sharing with others who don’t have access to the function

[@marcusfranconium3392]

@@CheatSheets True but doesnt exell updates update automaticly as i use the same microsoft office of 2013 and it updates every few months . Even if you change to a new computer your account is automatically updated and set up on your new laptop/pc ,