VLookup on Multiple Sheets in Excel

Рет қаралды 228,442

4 жыл бұрын

VLookup on Multiple Sheets in Excel - Overview
How To VLookup in Multiple tables or sheets in excel is a video demonstration of performing VLookup for values in more than one data range or a table.
VLookup helps you to lookup for values in a single data range or a table. However, using vLookup with the IFERROR function, we can lookup in more than one data range or a table.
So far, we have learned how to look up values in the same workbook • How to Use vLookup in ... and values from a different workbook • How to VLookup in Diff... . Through this demonstration, we will help you to learn how to perform vlookup and look for values in more than one data range.
We also cover the IFERROR function in this video demonstration. By the end of this video demonstration, you should be comfortable using IFERROR along with VLookup. In case if you are not familiar with nested functions, please visit this video • Excel Nested Functions to familiarise yourself with the idea of nested functions.
VLookup Practice Data File
If you plan to practice and follow along with me in this demonstration, kindly ensure to download the practice workbook on your computer using the link below:
drive.google.com/uc?export=do...
Download free Excel data xlsx format
If you are considering practicing more, you may download a free Excel dataset in xlsx format using the link below.
Free Excel Data for Practice: OnlineKnowledgePortal.com/201...
In case you are stuck, add your questions below in the comments section, and I will be happy to help you.
I hope that you're enjoying learning Excel through this Excel learning series with Syed. I request you to share these videos with anyone who desires to learn Excel from scratch.
Kindly subscribe to the channel and enable notifications by clicking on the bell icon to receive updates about new videos to keep up with Excel Learning.
These functions apply to:
Excel 2019, 2007, Excel 2010, Excel 2013, Excel 2016, Office 365, and above
#excelLearningSeries #excel #excel2016 #excelLookupFunction #HowWeExcel #excellookups #excelfunctions #exceldata #lookup

Пікірлер: 275

@ethanpavel1486

Thank a lot sir, been searching for this treasure😂😂😂😂😂😂 for 4 years and finally found........ Simply like and subscribe.

@SapnaDevi-g9v 21 күн бұрын

Finally i understand Vlookup and the practice sheet is the good one

@bradygrabowski5520

Thank you for this incredibly succinct and helpful tutorial! You just saved me countless hours of inherited data management.

@itsallenwow

I was having so much trouble with this, your video was brief but made searching across the multiple sheets I needed super easy. Well maybe not easy, but understandable lol. Great tutorial!

@ramesh-vm5gq Жыл бұрын

Before I have watched more than 10 youtube channels but I didn't understand now I understood one single video thank you so much sir.......

@sarikahoshing4662 Жыл бұрын

Explained so well. was very easy to execute + the practice worksheets are an added bonus.

@ndutawaweru 3 жыл бұрын

thank you so so much for this video. You have no idea what you have done for my reporting life. I am so grateful.

@karengarcia7528 Жыл бұрын

Thank you for explaining it so well. I definitely agree the more you practice the better you retain the information. Thank you Syed.

@richardcranium8776 2 жыл бұрын

Thank you for the tutorial. I viewed a number of other videos before yours and still couldn't figure it out, but your video helped me get the job done within minutes.

@bokooo3129 Жыл бұрын

even though i knew the iferror function i didn't immerse myself enough to get to this knowledge so thank you for the short cut it really saves time, Thank you again