Microsoft Excel Tutorial – Mastering VLOOKUP with Multiple Columns – Excel Tips & Tricks.

Welcome back to the MrExcel netcast where we continue our VLOOKUP week. In this video, we will be discussing how to use VLOOKUP with multiple columns. This can be a daunting task, especially when dealing with large amounts of data. But don’t worry, I’m here to show you some tips and tricks to make this process easier and faster.

First, we start by using the Equal VLOOKUP formula and locking down the column we want to reference. Then, we choose our table by using the Ctrl + Shift + Down Arrow and Shift + Right, Right, Right, Right. We then press F4 to lock the table and add a comma false at the end. This allows us to copy the formula across and always grab the correct column. However, the downside is that we have to manually edit each formula for each column, which can be time-consuming.

Another option is to use the Match function. We can enter a new column and use the Match function to find the row number of the value we are looking for. Then, we can use the Index function to retrieve the value from the corresponding column. This method is much faster as Match only has to run once and Index runs lightning fast. Plus, we can hide the extra rows we added, making our data more organized.

But what if we want to avoid using VLOOKUP altogether? Well, we can do that too. We can use the Match function to find the row number and then use that row number in the Index function to retrieve the value from the corresponding column. This method is even faster as we only need to use one Match and four Indexes to get all the answers we need.

So there you have it, multiple ways to use VLOOKUP with multiple columns. Whether you prefer the traditional VLOOKUP method or the faster Match and Index method, I hope this video has helped you in your Excel journey. Don’t forget to subscribe to our channel for more Excel tips and tricks. Thanks for watching and I’ll see you in the next netcast from MrExcel.

Buy Bill Jelen’s latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

Table of Contents:
(00:00) VLOOKUP week
(00:19) Using VLOOKUP to copy data across multiple columns
(01:02) Editing VLOOKUP formulas for multiple columns
(01:14) Alternative method using extra row and VLOOKUP
(02:10) Another alternative method using MATCH and INDEX functions
(03:38) Hiding unnecessary rows for a faster solution
(03:52) Clicking Like really helps the algorithm

VLOOKUP week continues…. Today, you have to lookup an account number and return the results from four columns in the lookup table. Episode 1123 shows you four possible solutions.Clicking Like really helps the algorithm

Update from 2023: There is a much easier way to do this if you have the XLOOKUP function. See this video: https://youtu.be/J-_2WmJZWao

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152689/