Excel PivotTable - Using XLOOKUP Function to Group Text

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 https://www.youtube.com/watch?v=6nnmbIx7oaQ XLOOKUP Function | Excel One Minute Functions Explained https://www.youtube.com/watch?v=M7XRIkCP3ls Excel Two-Way XLOOKUP - How to use XLOOKUP with two criteria in Excel | Nested XLOOKUP Tutorial https://www.youtube.com/watch?v=poAdZpw7oL8 Tax Brackets are Explained using Excel's awesome XLOOKUP function https://www.youtube.com/watch?v=z148REXdb78 XLOOKUP vs VLOOKUP & MATCH by Chris Menard https://www.youtube.com/watch?v=w1uglE7AhPw XLOOKUP - Excel's new awesome function by Chris Menard https://www.youtube.com/watch?v=1sSje27jnTA #chrismenardtraining #msexcel #pivottables #xlookup #microsoftexcel And make sure you subscribe to my channel! -- EQUIPMENT USED --------------------------------- ○ My camera – https://amzn.to/3vdgF5E ○ Microphone - https://amzn.to/3gphDXh ○ Camera tripod – https://amzn.to/3veN6Rg ○ Studio lights - https://amzn.to/3vaxyy5 ○ Dual monitor mount stand - https://amzn.to/3vbZSjJ ○ Web camera – https://amzn.to/2Tg75Sn ○ Shock mount - https://amzn.to/3g96FGj ○ Boom Arm - https://amzn.to/3g8cNi6 -- SOFTWARE USED --------------------------------- ○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia ○ Screenshots – Snagit – https://chrismenardtraining.com/snagit ○ YouTube keyword search – TubeBuddy – https://www.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!