How to Use VLOOKUP with Multiple Columns in Excel

How to Use VLOOKUP with Multiple Columns in Excel - Step by Step Guide

Рет қаралды 130,244

Күн бұрын

🔥 Are you trying to learn Microsoft Excel on KZbin? That's the slow way... Learn Excel the FAST way, find out how here 👉 www.excel-university.com/yt
Check out 7 Excel Time Hacks Everyone Should Know here • 7 Excel Time Hacks Eve...
In this video, you'll learn 4 ways to do a multi-column lookup in Microsoft Excel. I'm going to show you how to use the VLOOKUP function on two or more criteria columns and conditions. This can be a really powerful tool for finding data in your Excel spreadsheet. Let's take a look at how it works!
Subscribe here 👉 kzbin.info... and turn on all notifications 🔔 for MS Excel time hacks that will make you more productive!
Watch VLOOKUP Hacks Playlist here • VLOOKUP Hacks Series
Watch VLOOKUP vs SUMIFS Playlist here • VLOOKUP vs SUMIFS Series
Watch Dynamic Arrays playlist here • Dynamic Arrays Series
Watch Treasure Maps playlist here • Treasure Maps Series
Watch Slow to Fast playlist here • Slow to Fast Series
Table of Contents:
00:00 - Introduction
00:12 - Objective
00:59 - SUMIFS
03:18 - VLOOKUP
06:02 - XLOOKUP
07:13 - FILTER
08:54 - Conclusion

Пікірлер: 31

@earleast3 Жыл бұрын

Thank you - Xlookup worked. For those who might have problems, make sure to check your look up arrays.

@krisocampo3772 8 ай бұрын

you are the best in explaining things in excel! please don’t ever get tired in sharing your knowledge 😭. I’ll be the one supporting you till the end

@amitsgy 9 сағат бұрын

@arthursimione4600 7 ай бұрын

Wow, solved my problem in so many ways! Very clear and straight forward. Thanks for the video!

@PaulEBrownbill Жыл бұрын

Good explanation, thanks Paul

@ravitejamom Ай бұрын

🙏🙏🙏🙏thanks a lot.....that's a great value addition

@Ks-lm6kv 10 ай бұрын

Thank you 🙏

@TommyYamaha576 7 ай бұрын

great vid thanks alot

@ashimasingh7578 Жыл бұрын

Very nicely explained...thanks a lot!

@ExcelU Жыл бұрын

Thanks :)

@HemanthSopparapu 3 ай бұрын

Thank you :)

@ericmauriello5359 Жыл бұрын

You are rock star!.. amazing. Thanks.

@ExcelU Жыл бұрын

Thanks Eric for your kind note ... and glad the video helped!

@heryoheryo6148 2 ай бұрын

thanks paul

@MahmoudAAziz 10 ай бұрын

Thank you, I'm adding XLookup to my repertoire

@ExcelU 10 ай бұрын

That's great to hear!

@MrRajessh84 Жыл бұрын

Good!

@ExcelEssentials_ 9 ай бұрын

Important note: when you have a spreadsheet with a lot of columns: just make sure that the column with the lookup value is simply left of the column you want to search in. The Vlookup function can only search to the right! Good luck 😊

@mwa1252 7 ай бұрын

This is good but what if you need to lookup a value from a multi column table that has one-to-one relationships? In other words, COLUMN ONE lists values A = 1, B=2, C=3, and so on Down the column. COLUMN TWO continues on where column one left off. For example Z = 26, Z1 = 27, Z2 = 28 and so on down. Then COLUMN THREE picks up where column two left off and so on. So the lookup needs to search down column one then down column 2 then down column three etc.

@Bhavik_Khatri Жыл бұрын

Very nice tutorial.

@ExcelU Жыл бұрын

Thank you :)

@Yasmin-iz4hm 2 ай бұрын

How did you get the down arrow to pop up when highlighting the cells?

@eslamfahmy87 Жыл бұрын

Thank you Dear...but if i want to use the vlookup example but my data has only content of ( text or barcodes & total Qty), Also, some of my date are Duplicated, so, how I can use the sumifs along with Vlookup and if possible I can share with you sir my data to be an example to other in such cases.

@cathyluong2949 Жыл бұрын

What if I have text in two columns that need to match a condition in a range, and return a result. Ex. Column A= A, Column B=B, Range: row 1=A and B, row 2=A and C

@real.monaliza8283 4 ай бұрын

Need help on a project (that I want to do - but I am not an Excel guru) that I am in over my head, a bit ambitious excel project - but would really be a game changer for my workload. Can anyone connect to work on it? It's quite a challenge. THANKS IN ADVANCE.

@bertfernandez5163 8 ай бұрын

Hi sir, can I have an answered about how can I solve my problem about if I input the Column A (Letter)& Column B (Number) that read the Column C (Letter Title).

@jithendrareddytamma6565 5 ай бұрын

🙏🙏🙏🙏🙏

@FiachnaG Жыл бұрын

well that didn't answer the question al all. you focused on adding sums rather than returning a value in column 3 if column a & B are the same as Column A & B of your sheet...