How to VLOOKUP in 30 seconds
Рет қаралды 960,389
2 жыл бұрын📚 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 5 ай бұрын
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 11 ай бұрын
brehhhhhhhh
@theondrahamilton9988 7 ай бұрын
Usain Flash 😂
@migamafiri6473 5 ай бұрын
@@theondrahamilton9988Phil MickelDAD
@anujoseph_10 3 ай бұрын
That's why you won't be getting a job😂
@jahimuddin2306 3 ай бұрын
@@anujoseph_10, I have a job.
@ashielovestolearn 4 ай бұрын
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 3 ай бұрын
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 6 ай бұрын
See the advance than Vlookup :kzfaq.info/get/bejne/aa-Cf82kldeUZpc.htmlsi=p4S6i3Q994Yeui9E
@phandongexcel 16 күн бұрын
Tôi thích nội dung này
@Mystic5683 7 ай бұрын
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 5 ай бұрын
Great info. Do you have any good resource to master structured tables?
@Sickofadgendas 4 ай бұрын
Very anxious to master excel. please share
@sheeplestrafer9413 3 ай бұрын
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.
@cmondragon0911 8 ай бұрын
I am following the instructions and getting #N/A's.
@nirmalrana9439 Ай бұрын
Nice.... awesome and short
@CheatSheets Ай бұрын
Glad you enjoyed this one! Let us know if you ever have any questions or video requests 💚
@motivation_m00d 8 ай бұрын
Great and helpful 😊
@jh.5687 4 ай бұрын
Those names satisfy me to Live 😂. It's a life changing! 😂😂😂
@mj1reyes 7 ай бұрын
Thank you for this
@jhonnmaicol6692 5 ай бұрын
Awesome, thanks 👍
@ronroca4387 3 ай бұрын
You saved the day
@hydgurl77 4 ай бұрын
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 🙂
@stevew3947 10 ай бұрын
"Shake Oneil" 😂 great example hilarious name
@CheatSheets 10 ай бұрын
Happy to hear the names gave you a laugh 😂
@Anas_fazil 9 ай бұрын
You know shit about to go down When you see Christian Ronaldo top of the table
@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 11 ай бұрын
Great tutorials.👌👍
@CheatSheets 11 ай бұрын
Happy to hear you’re enjoying them! 😁
@mahmoodalmahmood7014 4 ай бұрын
Thanks
@Haudidau 6 ай бұрын
Great video, very good pixel quality! Unfortunately it's useless for someone trying to figure out how to use vlookup
@lurk- 3 ай бұрын
These names are hilarious 😂
@keisycruz3958 10 ай бұрын
wow, super helpful
@emalynudtujan8531 Жыл бұрын
Thanks for this❤
@CheatSheets Жыл бұрын
You're so welcome! 💚
@pratapkeshavpawar9689 4 ай бұрын
🕉️🇮🇳🙏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 पी के पंवार
@manjulakarthik2157 Жыл бұрын
insted of I'd no type, create a list ( data validation - settings - list) no need of type each and every time
@sreejithksmail 7 ай бұрын
why i never thought about it before?.....
@gregoryking4796 6 ай бұрын
XLOOKUP for the W tho
@_choxa_92006 Ай бұрын
cristiano ronaldo......is even in excel..true goat
@pocketsdsquirrel3207 7 ай бұрын
Xlookup is the future
@user-pn3bw6zp8k 10 ай бұрын
95% of excel users don’t require to use vlookup
@CheatSheets 10 ай бұрын
VLOOKUP is a super powerful function! However, if you have access to the XLOOKUP function, we definitely recommend using that instead 😁
@martysherlock 6 ай бұрын
You get n/a in the result cell if the id lookup value cell is empty,i.e no value is entered
@yourplaylistmusic. 3 ай бұрын
How to press "F4" on excel in macbook air? Is it shift + 4?
@kuldeepmaurya9673 5 ай бұрын
What is the Shortcut for selection of whole data
@kenlingatong5913 3 ай бұрын
up. I want to know also
@arcangeld 2 ай бұрын
When you only have a match, every problem looks like an indec
@scarletfoxfrostnovember3407 7 ай бұрын
Is there a source file to try it myself? This function is very new to me!!!
@tabularasa421 3 ай бұрын
Index match when you need more flexibility
@silviamtz8961 8 ай бұрын
I don't see what has been changed and I've been looking. Can someone explain please?
@vonsalamera3766 7 ай бұрын
Is it functionable also in Spreadsheet?
@valerioharvey7289 4 ай бұрын
Christian Ronaldo is the most american thing I've seen today
@MyMomHadMe 4 ай бұрын
What happens if 19 is in there twice?
@Bashar._.1612 3 ай бұрын
What is the ,2, ?
@saifulla0717 Жыл бұрын
How to copy that data to my Excel sheet it's possible to copy your KZfaq data in my exel sheet
@Paulo-om4wv 2 ай бұрын
Are you one of them durfa turka?
@danielminnear9620 4 ай бұрын
Still have no idea what vlookup can do that xlookup can’t.
@8Jallin 9 ай бұрын
I need this in Python how do I ask chatgpt
@riggyB 2 ай бұрын
You can put 0 in place of FALSE as well.
@CheatSheets 2 ай бұрын
Definitely! We prefer using FALSE as it’s a bit more intuitive 😊
@Absta86 2 жыл бұрын
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 11 ай бұрын
then it shows #N/A
@scrumbaker 8 сағат бұрын
Gee thanks for reposting what we learned in 3rd grade. Go FY
@rocodux 3 ай бұрын
❤❤❤❤❤ by 100000
@candicetomlin5612 4 ай бұрын
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 4 ай бұрын
Try the if function instead
@softwaredynamicsolutions 8 ай бұрын
👍👍👍
@katielarsen2630 5 ай бұрын
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 4 ай бұрын
Use a filter() for that
@thomass1891 5 ай бұрын
I’ll still forget it 😂
@lalitjadoun8800 9 ай бұрын
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 9 ай бұрын
We apologize, we’re not sure we fully understand your problem. Would you mind clarifying?
@user-bp6oh3py5d 10 ай бұрын
Do u have long video for view lookup?
@CheatSheets 10 ай бұрын
Do you mean the LOOKUP function? If so, then yes, we do have a video on this topic! 🙂
@erick2051 4 ай бұрын
hey, where did you get the 95% statistic source from?
@bobgreenfield9158 21 күн бұрын
43% of all statistics are made up!
@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 😁
@user-je5fb5gy8q 5 ай бұрын
how did you highlight the whole table like that?
@iamtheman4416 4 ай бұрын
Ctrl + A after selecting any cell in the table
@BraidenPlayz138 7 ай бұрын
Names are so funny
@marshaletim5862 2 ай бұрын
Mine is showing #N/A
@CheatSheets 2 ай бұрын
Be sure to follow the steps exactly as shown in this video! Let us know if you’re still having trouble 😊
@mrgameplays7551 9 ай бұрын
What did that 2 mean? The Column number was not 2! Please explain
@CheatSheets 9 ай бұрын
Yes! 2 represents the column number of the result column in relation to the table_array selected in the second portion of the syntax 🙂
@trapbeats5844 3 ай бұрын
Bad loud music
@DarkSide-mx3id 6 ай бұрын
How to hide error value IF no need to key in the data id... this value -> #N/A
@DarkSide-mx3id 6 ай бұрын
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 😅
@The_Python_Turtle 7 ай бұрын
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 => kzfaq.infoZrCPOYnxuSg?feature=share
@apips.studios7677 Жыл бұрын
leebroff jamess lol
@CheatSheets Жыл бұрын
hehe 🤭
@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.
@septea7032 5 ай бұрын
Christian Ronaldo okay Lebroff james i dont care But whyyy Federerer
@Reekay47 10 ай бұрын
Lol Floyd Juneweather.
@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 9 ай бұрын
@@tintinfan007 No BUT's?
@tintinfan007 9 ай бұрын
@@casr01 why don't you use it if you like it so much
@jehad1582 6 ай бұрын
And u used vlookup with out list ?? Lol use list for id they will be very easy to u❤
@mohamedmehraz3537 9 ай бұрын
Hilarious 😂
@CheatSheets 9 ай бұрын
Glad you enjoyed this! 😊
@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
@cooptexissrmdu4697 2 ай бұрын
FOR BULK DATA IT IS NOT WORKING
@CheatSheets 2 ай бұрын
We’d be happy to help - would you mind explaining where you’re running into an issue?
@_sonicfive 4 ай бұрын
There are far better functions like filter()
@sassouusasoo3607 9 ай бұрын
🙄🙄🥱
@MS-zp7bt 6 ай бұрын
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.
@marcusfranconium3392 10 ай бұрын
Most people use X lookup
@CheatSheets 10 ай бұрын
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 10 ай бұрын
@@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 ,
Excel Campus - Jon
Рет қаралды 14 МЛН
Online Training for Everyone
Рет қаралды 3 МЛН
Jopa Excel
Рет қаралды 317 М.