Excellent video of tips! I have used VLOOKUP with named arrays or tables before, but nice to see these other options without naming the array or table.
Hi John.. great video! Very comprehensive. I can't think of anything you left out. Even though I'm familiar with and use VLOOKUP often, this was a super review and brain tickler to remember all of the important things to know about VLOOKUP. Thanks and Thumbs up!! PS - I watch a lot of EXCEL videos and I think your style and presentation is superior. I find your videos engaging and interesting, as well as informative and relevant. I'm here to learn and so enjoy the fact that you keep it about EXCEL and not about trying to entertain or grandstand. So.. I'm a fan : )) Keep them coming! One thing.. any chance of providing links to your example worksheets for those who like to follow along? I can always re-create a short data set, but it's a nice time saver to get a download link.. just a thought or suggestion. Thanks again.
@@HowToExcelBlog Thanks John.. that would be great. I like to follow along and so if on the same data set, can match what you do in the video. Looking forward to it. Thumbs up!
Hello John, thanks for this information. Does " =IFERROR(=VLOOKUP " work across different worksheet (same workbook) reference? I have been trying get it to work with no success.
Check out my full courses and ebooks here
👉 www.howtoexcel.org/courses/
Probably the best vlookup help video I have watched. Thanks
Thanks Mark! Glad to hear you think so!
Really thorough, and I hadn't thought of using CHOOSE for a leftward lookup - great tip!
Yes, I became a bigger fan of CHOOSE when I discovered that trick!
Do you have any favourite VLOOKUP tricks?
@@HowToExcelBlog if i want lookup 20 column value.how this formula work.
do i have to write 20 time in choose function like choose{1,2,3,4,5,6,7,8,......20}
Thanks so much, I learned a lot.
Very helpful. I have learnt new things even though i am using VLOOKUP since a long time.
Thanks
There's always some new detail to learn in Excel!
I got benefited from this, So it’s not fare to leave without appreciation you. Thank you and god bless you. Regards
I appreciate the comment, glad to hear it benefited you!
Very enlightening. Thank you
You're welcome!
Excellent video of tips! I have used VLOOKUP with named arrays or tables before, but nice to see these other options without naming the array or table.
Yes, there are usually lots of ways to do something in Excel!
Do you have any other VLOOKUP tips?
You have a very easy to listen to voice. Great pace too!
Thanks Rick! 👍
Hi John.. great video! Very comprehensive. I can't think of anything you left out. Even though I'm familiar with and use VLOOKUP often, this was a super review and brain tickler to remember all of the important things to know about VLOOKUP. Thanks and Thumbs up!!
PS - I watch a lot of EXCEL videos and I think your style and presentation is superior. I find your videos engaging and interesting, as well as informative and relevant. I'm here to learn and so enjoy the fact that you keep it about EXCEL and not about trying to entertain or grandstand. So.. I'm a fan : )) Keep them coming! One thing.. any chance of providing links to your example worksheets for those who like to follow along? I can always re-create a short data set, but it's a nice time saver to get a download link.. just a thought or suggestion. Thanks again.
Good idea Wayne! I'll try to add the workbooks to the last few videos in the next couple days and to all videos going forward.
@@HowToExcelBlog Thanks John.. that would be great. I like to follow along and so if on the same data set, can match what you do in the video. Looking forward to it. Thumbs up!
Thanks, excellent information.
No problem!
I am new to this and your video is realy helpful and easy to follow. Thank you and be blessed
Thanks for the blessing 😇
Thanks for the video. Some great tips.
No problem Jan. Any favourites out of them?
very helpful tutorial, thanks a lot.
thank you it is exactly what I need
Good to hear Carlos!
Hello, John. Thank you for sharing information about VLOOKUP. Extremely useful
. Realy realy good video. Great video! Keep it going.
Hi Nikolay. Glad to hear you enjoyed it!
Any other topics you would like to see?
@@HowToExcelBlog For whatever you have the readiness and desire. I prefer something with the VBA, but you decide. This video was great!
Hello John, thanks for this information. Does " =IFERROR(=VLOOKUP " work across different worksheet (same workbook) reference? I have been trying get it to work with no success.
You probably just need to get rid of the second equal sign in the formula.
Great Video!!!
Thanks Samsung!
Great video, thank you
Hi Sul! Thanks.
Are there any other topics you'd like to see in my videos?
very useful
Glad you found it useful Steven!
excellent
Thanks!
superb
Thanks!
Watched a ton of V lookup videos it finally clicked on this video
Oh, good to hear! Next up, XLOOKUP, the successor to VLOOKUP.
Where is the download file for this? Your link only asks to enter your name and email but then we don't get the downloads.
Check you junk, spam or other folders.
@@HowToExcelBlog I checked it and there is nothing. I tried many times and I am not able to download any file. Thanks
Excellent vidoes however I've subscribed to your newsletter and received nothing!
Check all folders, it's there somewhere.
i don't find thé file ton download 😥
19 things!? I didn’t know this much about my wife when I married her
I’m getting dv’d
Haha 😂
Well, don't marry VLOOKUP just yet because XLOOKUP is coming to Excel soon!