Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Excel VLOOKUP To Return Many Columns Now Easier With XLOOKUP – Episode 2594

Posted on by Annie D

Microsoft Excel Tutorial: Returning many columns from a lookup.
If you do not have the XLOOKUP function, then use the techniques from episode 1123: https://www.youtube.com/watch?v=T_L2XAC0kq8

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

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.

MrExcel.comWed, April 26, 2023 7:44am