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 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
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!😊
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.
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.
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 🙂
🕉️🇮🇳🙏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 पी के पंवार
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 😁
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?
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 => ruclips.net/user/shortsZrCPOYnxuSg?feature=share
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 😅
@@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.
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.
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
@@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 ,
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!!
Do you know how to select the entire table without dragging it with the mouse?
@@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
exactly .fr im sayin this i just saw a 30min expln video suggn and ths short next to it.this was simple and more effective.
I spent the entire video looking at the names.
brehhhhhhhh
Usain Flash 😂
@@theondrahamilton9988Phil MickelDAD
That's why you won't be getting a job😂
@@anujoseph_10, I have a job.
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!
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!😊
This was really helpful, thank you!
Happy to help! 💚
See the advance than Vlookup :ruclips.net/video/3IRLjs0q06c/видео.htmlsi=p4S6i3Q994Yeui9E
@@CheatSheetsteach us how to create QR code
Iam learning with all xl work, thanks ❤
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.
Great info. Do you have any good resource to master structured tables?
Very anxious to master excel. please share
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.
This was helpful! Also, I enjoyed reading the names 😂
Those names satisfy me to Live 😂. It's a life changing! 😂😂😂
Nice.... awesome and short
Glad you enjoyed this one! Let us know if you ever have any questions or video requests 💚
"Shake Oneil" 😂 great example hilarious name
Happy to hear the names gave you a laugh 😂
Tôi thích nội dung này
After selecting B2 in the look up what did you do to select the entire two columns ?
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 🙂
You know shit about to go down When you see Christian Ronaldo top of the table
Soooo easyyyyyyyyyyyy.. Thanks session a ton
Glad you liked this tip! Let us know if you ever have any questions or requests 💚
I am following the instructions and getting #N/A's.
Yeah me too 😢
U can use Name Range like Vtable instead of selecting data every now n then.
cristiano ronaldo......is even in excel..true goat
XLOOKUP for the W tho
insted of I'd no type, create a list ( data validation - settings - list) no need of type each and every time
why i never thought about it before?.....
These names are hilarious 😂
Thanks a lot sir
I made a list of products name and price and people whom have bought it, how do i do a fusion of the bought products according to the clients names
🕉️🇮🇳🙏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
पी के पंवार
95% of excel users don’t require to use vlookup
VLOOKUP is a super powerful function! However, if you have access to the XLOOKUP function, we definitely recommend using that instead 😁
Great video, very good pixel quality! Unfortunately it's useless for someone trying to figure out how to use vlookup
You saved the day
Great
Great tutorials.👌👍
Happy to hear you’re enjoying them! 😁
Awesome, thanks 👍
Xlookup is the future
Thank you for this
Great and helpful 😊
@cheatsheet pls teach us how to create QR CODE on excel
What is the Shortcut for selection of whole data
up. I want to know also
Thanks
Thanks for this❤
You're so welcome! 💚
How to press "F4" on excel in macbook air? Is it shift + 4?
wow, super helpful
You get n/a in the result cell if the id lookup value cell is empty,i.e no value is entered
Gee thanks for reposting what we learned in 3rd grade. Go FY
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)?
Use a filter() for that
How do you use vlookup if you want a value on sheet 1 if found on sheet 2 to say a word like "approved"?
Try the if function instead
Christian Ronaldo is the most american thing I've seen today
Can someone explain to me why "true" is apx?
I don't see what has been changed and I've been looking. Can someone explain please?
what are the differences between vlookup and filter function ?
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 😁
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
We apologize, we’re not sure we fully understand your problem. Would you mind clarifying?
You can put 0 in place of FALSE as well.
Definitely! We prefer using FALSE as it’s a bit more intuitive 😊
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?
then it shows #N/A
hey, where did you get the 95% statistic source from?
43% of all statistics are made up!
Index match when you need more flexibility
When you only have a match, every problem looks like an indec
Is it functionable also in Spreadsheet?
Is there a source file to try it myself? This function is very new to me!!!
What is the ,2, ?
❤❤❤❤❤ by 100000
Do u have long video for view lookup?
Do you mean the LOOKUP function? If so, then yes, we do have a video on this topic! 🙂
What happens if 19 is in there twice?
What did that 2 mean? The Column number was not 2! Please explain
Yes! 2 represents the column number of the result column in relation to the table_array selected in the second portion of the syntax 🙂
Are you one of them durfa turka?
how did you highlight the whole table like that?
Ctrl + A after selecting any cell in the table
the names 😂😂
How to copy that data to my Excel sheet it's possible to copy your RUclips data in my exel sheet
I’ll still forget it 😂
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 => ruclips.net/user/shortsZrCPOYnxuSg?feature=share
Christian Ronaldo okay
Lebroff james i dont care
But whyyy Federerer
How to hide error value IF no need to key in the data id... this value -> #N/A
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 😅
Still have no idea what vlookup can do that xlookup can’t.
Or you know... Use cntrl F?
Woossshhh
cant always do that when u have 2 sheets u working from
doesnt work on big files with 2 excel sheets
no problem doing it except that MY TEACHER WANTS IN IN SPECIFIC TYPES OF LOOKUPS FOR SOME STUPID AHH REASON
Quiet, grown ups are talking.
There are far better functions like filter()
Forget vlookup and hlookup...do excel users even know how to use logic functions such as AND & OR. and IF loops
All of these are super important to learn! We have videos on each of these topics 😁
@@CheatSheets I know...I am already an expert with IF, AND and OR
@@tintinfan007 No BUT's?
@@casr01 why don't you use it if you like it so much
Bad loud music
I need this in Python how do I ask chatgpt
And u used vlookup with out list ?? Lol use list for id they will be very easy to u❤
Mine is showing #N/A
Be sure to follow the steps exactly as shown in this video! Let us know if you’re still having trouble 😊
If you are still using and teaching Vlookup in 2023, you clearly have no idea what you are doing.
Why ?
@@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.
😂😂😂
Index and match combination.
Much better and quick in calculation
@@StuninRub maybe u should make tutor video for that
FOR BULK DATA IT IS NOT WORKING
We’d be happy to help - would you mind explaining where you’re running into an issue?
leebroff jamess lol
hehe 🤭
Names are so funny
0:10
Lol Floyd Juneweather.
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.
Hilarious 😂
Glad you enjoyed this! 😊
👍👍👍
🙄🙄🥱
Most people use X lookup
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
@@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 ,