Stop Using Long Formulas: Try '*' and '?' Instead

About this lesson

Make Excel formulas smarter with the Asterisk (*) and Question Mark (?) 🚀 Find all our courses here: https://www.careerprinciples.com/all-courses 🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/lzdgdx7fzt In this video, you learn how to use the asterisk and the question mark in Excel. This applies to many Excel formulas, including Sumifs, Countifs, XLOOKUP, INDEX-MATCH, and even the Filter tool. Both the question mark and the asterisk are for approximate or partial matches. The asterisk (also known as a wildcard) is for any number of characters, while the question mark is for a specific number of characters only. First, you learn how to use the asterisk with the Countifs function, followed by the question mark with the same Countifs. Then we'll go over the asterisk for the Find and Replace tool as well as the Filter tool. Following this, we'll go over how to use the wildcard (*) with more advanced functions, including the XLOOKUP and the INDEX-MATCH. Unfortunately, the XLOOKUP and index match only give one match. But when you have multiple matches, we'll show you an alternative using the filter function. LEARN: 👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance 📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course 🔥 Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Chapters: 0:00​ -​ Asterisk (*) 2:30​ - Question Mark (?) 3:31​ - Wildcard with Find & Replace and Filter Tool 5:26​ - Wildcard XLOOKUP 7:46​ - Wildcard INDEX MATCH 9:20​ - Multiple Matches

Original Description