https:\/\/www.youtube.com\/watch?v=T_L2XAC0kq8<\/a><\/p>\nIn 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.<\/p>\n
How to apply vlookup in excel to get multiple columns values.
\nHow to return 12 months from a VLOOKUP in Excel.
\nHow to return multiple columns from a VLOOKUP in Excel.
\nHow to return 52 weeks from a VLOOKUP in Excel.
\nReturn all columns from VLOOKUP in Excel.
\nReturn an entire row from VLOOKUP in Excel.
\nHow to apply xlookup in excel to get multiple columns values.
\nHow to return 12 months from a XLOOKUP in Excel.
\nHow to return multiple columns from a XLOOKUP in Excel.
\nHow to return 52 weeks from a XLOOKUP in Excel.
\nReturn all columns from XLOOKUP in Excel.
\nReturn an entire row from XLOOKUP in Excel.<\/p>\n
Table of Contents
\n(0:00) Old Method with VLOOKUP
\n(0:30) XLOOKUP to return many columns
\n(1:37) Wrap-up<\/p>\n","protected":false},"excerpt":{"rendered":"
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 […]<\/p>\n","protected":false},"author":3,"featured_media":5609,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[21,142,138],"tags":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/bonbonsguide.com\/wp\/wp-content\/uploads\/2023\/04\/J-_2WmJZWao.jpg?fit=1280%2C720&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7QB1z-1ss","_links":{"self":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/5608"}],"collection":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/comments?post=5608"}],"version-history":[{"count":0,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/5608\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media\/5609"}],"wp:attachment":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media?parent=5608"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/categories?post=5608"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/tags?post=5608"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}