Microsoft Excel Tutorial: Returning many columns from a lookup.
If you do not have the XLOOKUP function, then use the techniques from episode 1123:
In the past, if you needed to return 4 quarters or 12 months or 52 weeks from a VLOOKUP, it required some trickery or helper cells. Today, the new XLOOKUP function makes it simple to return many columns from a lookup in Excel.
How to apply vlookup in excel to get multiple columns values.
How to return 12 months from a VLOOKUP in Excel.
How to return multiple columns from a VLOOKUP in Excel.
How to return 52 weeks from a VLOOKUP in Excel.
Return all columns from VLOOKUP in Excel.
Return an entire row from VLOOKUP in Excel.
How to apply xlookup in excel to get multiple columns values.
How to return 12 months from a XLOOKUP in Excel.
How to return multiple columns from a XLOOKUP in Excel.
How to return 52 weeks from a XLOOKUP in Excel.
Return all columns from XLOOKUP in Excel.
Return an entire row from XLOOKUP in Excel.
Table of Contents
(0:00) Old Method with VLOOKUP
(0:30) XLOOKUP to return many columns
(1:37) Wrap-up
If you do not have the XLOOKUP function, then use the techniques from episode 1123:
In the past, if you needed to return 4 quarters or 12 months or 52 weeks from a VLOOKUP, it required some trickery or helper cells. Today, the new XLOOKUP function makes it simple to return many columns from a lookup in Excel.
How to apply vlookup in excel to get multiple columns values.
How to return 12 months from a VLOOKUP in Excel.
How to return multiple columns from a VLOOKUP in Excel.
How to return 52 weeks from a VLOOKUP in Excel.
Return all columns from VLOOKUP in Excel.
Return an entire row from VLOOKUP in Excel.
How to apply xlookup in excel to get multiple columns values.
How to return 12 months from a XLOOKUP in Excel.
How to return multiple columns from a XLOOKUP in Excel.
How to return 52 weeks from a XLOOKUP in Excel.
Return all columns from XLOOKUP in Excel.
Return an entire row from XLOOKUP in Excel.
Table of Contents
(0:00) Old Method with VLOOKUP
(0:30) XLOOKUP to return many columns
(1:37) Wrap-up
Transcript of the video:
VLOOKUP to return many columns is easier with XLOOKUP.
I have this popular video from 13 years ago. Of how to return multiple columns from a VLOOKUP.
Lots of different methods there. But there's a much easier way today.
If you don't have XLOOKUP, and you arrived at this video.
Go check out this old video with four perfectly good ways that work in the old Excel.
If you have the new Excel, it is so much simpler today.
Get rid of any VLOOKUP you might have. Equal XLOOKUP so =XL tab.
We're looking up the account number in A5. We don't need a dollar sign there.
Comma.
Come over here and point to the first row of your lookup table with what you're looking up. Control + shift + down arrow.
Control+backspace. Press F4 to lock that down.
What do we want to return?
Well, this is where, in XLOOKUP you typically would say, "I want to return all these values in Q1.," But instead, I'm going to do Control + Shift + Right arrow.
Still holding down Ctrl and Shift. Press the down arrow to select the entire range.
Control + backspace, F4, that's it.
We don't need comma false anymore, it's implied by XLOOKUP. Closing, press Enter.
And you get all four values from one formula.
Then just drag to copy it down and you're good to go. Look, it's a shorter formula.
Faster to calculate, no trickery, no helper cells.
Kudos to the Excel team for creating this awesome improvement over the old VLOOKUP. Hey, thanks for all stopping by.
We'll see you next time for another net cast from MrExcel.
If you like these videos, please, down below, Like, Subscribe, and Ring the Bell.
Feel free to post any questions or comments down in the comments below.
I have this popular video from 13 years ago. Of how to return multiple columns from a VLOOKUP.
Lots of different methods there. But there's a much easier way today.
If you don't have XLOOKUP, and you arrived at this video.
Go check out this old video with four perfectly good ways that work in the old Excel.
If you have the new Excel, it is so much simpler today.
Get rid of any VLOOKUP you might have. Equal XLOOKUP so =XL tab.
We're looking up the account number in A5. We don't need a dollar sign there.
Comma.
Come over here and point to the first row of your lookup table with what you're looking up. Control + shift + down arrow.
Control+backspace. Press F4 to lock that down.
What do we want to return?
Well, this is where, in XLOOKUP you typically would say, "I want to return all these values in Q1.," But instead, I'm going to do Control + Shift + Right arrow.
Still holding down Ctrl and Shift. Press the down arrow to select the entire range.
Control + backspace, F4, that's it.
We don't need comma false anymore, it's implied by XLOOKUP. Closing, press Enter.
And you get all four values from one formula.
Then just drag to copy it down and you're good to go. Look, it's a shorter formula.
Faster to calculate, no trickery, no helper cells.
Kudos to the Excel team for creating this awesome improvement over the old VLOOKUP. Hey, thanks for all stopping by.
We'll see you next time for another net cast from MrExcel.
If you like these videos, please, down below, Like, Subscribe, and Ring the Bell.
Feel free to post any questions or comments down in the comments below.
