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

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!

Table of Contents:
00:00 - Introduction
00:12 - Objective
00:59 - SUMIFS
03:18 - VLOOKUP
06:02 - XLOOKUP
07:13 - FILTER
08:54 - Conclusion

[krisocampo]

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

[earleast]

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

[arthursimione]

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

[MahmoudAAziz]

Thank you, I'm adding XLookup to my repertoire

[mwa]

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.

[ExcelEssentials_]

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 😊

[Yasmin-izhm]

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

[eslamfahmy]

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.

[real.monaliza]

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.

[cathyluong]

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

[bertfernandez]

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).

[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...

[rlevass]

Your formulas using Table lost me... i assume you are somehow labeling your data first?