The XLOOKUP function is one of my favorite functions in Microsoft Excel. We will use the XLOOKUP to group text for our PivotTable. The other day I made a video showing how to group text directly inside the PivotTable, but today we're going to use XLOOKUP to add the text to our data and then create the PivotTable. I'll also cover why I prefer XLOOKUP to VLOOKUP.

Chapters:
0:00 Intro
0:35 XLOOKUP
1:24 XLOOKUP vs. VLOOKUP
4:13 Calculated Column in a Table
5:50 PivotTable

XLOOKUP videos by Chris Menard
------
EXCEL: HLOOKUP Function vs. XLOOKUP Function - Comparison youtube.com/watch?v=6nnmbIx7oaQ
XLOOKUP Function | Excel One Minute Functions Explained youtube.com/watch?v=M7XRIkCP3ls
Excel Two-Way XLOOKUP - How to use XLOOKUP with two criteria in Excel | Nested XLOOKUP Tutorial youtube.com/watch?v=poAdZpw7oL8
Tax Brackets are Explained using Excel's awesome XLOOKUP function youtube.com/watch?v=z148REXdb78
XLOOKUP vs VLOOKUP & MATCH by Chris Menard youtube.com/watch?v=w1uglE7AhPw
XLOOKUP - Excel's new awesome function by Chris Menard youtube.com/watch?v=1sSje27jnTA

#chrismenardtraining #msexcel #pivottables #xlookup #microsoftexcel

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------
○ My camera – amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod – amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera – amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6

-- SOFTWARE USED ---------------------------------
○ Screen recording – Camtasia – chrismenardtraining.com/camtasia
○ Screenshots – Snagit – chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – tubebuddy.com/chrismenard

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

• Excel PivotTable - Using XLOOKUP Function to Group Text ( Download)
• You Won't Believe These Crazy PIVOT TABLE Hacks! ( Download)
• Advanced Pivot Table Techniques (to achieve more in Excel) ( Download)
• Excel Data Modeling - Stop Using XLOOKUP | Learn PowerPivot ( Download)
• Use XLOOKUP and Pivot Tables in Excel to Create Dynamic Graphs ( Download)
• 💫Use GETPIVOTDATA to extract information from a Pivot Table – Essential Pivot Table Skills☝️ ( Download)
• How to use the XLOOKUP Function in Microsoft Excel - Beginners Tutorial ( Download)
• XLOOKUP Function and Pivot Tables ( Download)
• Pivot Table Excel Tutorial ( Download)
• Excel's TEXTJOIN VSTACK XLOOKUP Functions ( Download)
• 10 Useful Functions of XLOOKUP: Step-by-Step Tutorial with Examples ( Download)
• Add New Fields in a PivotTable using Calculated Fields ( Download)
• How to use XLOOKUP in Microsoft Excel: XLOOKUP Function Tutorial ( Download)
• Pivot Tables: MUST-KNOW for Business & Finance Professionals ( Download)
• Xlookup Function In Excel | Find Most & Least Expensive Item In List Using XLookup Function | #excel ( Download)