MATCH function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/match-function/ Bestselling Excel and Power BI Courses Fri, 24 Mar 2023 08:31:10 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png MATCH function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/match-function/ 32 32 How to Create MULTIPLE Dependent Drop-Down Lists in Google Sheets https://www.xelplus.com/google-sheets-multiple-dependent-dropdown-lists/ Tue, 15 Dec 2020 12:40:00 +0000 https://www.xelplus.com/?p=9182 There is a trick you can use to create multiple dependent drop-down lists on the same sheet in Google sheets. It's simple trick that doesn't involve Apps Script. Check it out here.

The post How to Create MULTIPLE Dependent Drop-Down Lists in Google Sheets appeared first on Xelplus - Leila Gharani.

]]> How to Setup Dependent Drop-Down Lists in Google Sheets https://www.xelplus.com/google-sheets-dependent-drop-down-lists/ Tue, 08 Dec 2020 12:00:00 +0000 https://www.xelplus.com/?p=10395 Learn how to create dependent drop-down lists in Google Sheets. Dependent drop-downs can be tricky in Google Sheets because you can't add a formula to the drop-down version of the data validation. But there is another way.

The post How to Setup Dependent Drop-Down Lists in Google Sheets appeared first on Xelplus - Leila Gharani.

]]> How to Get Multiple Match Results in Excel Without the FILTER Function https://www.xelplus.com/excel-multiple-match-results-complete/ Thu, 28 May 2020 09:00:00 +0000 https://www.xelplus.com/?p=11320 If you don't have the Filter function in Excel, you need to check out this easy formula approach to get multiple match results in Excel. Download the workbook and use the version that fits your problem best.

The post How to Get Multiple Match Results in Excel Without the FILTER Function appeared first on Xelplus - Leila Gharani.

]]> How to Create Excel Dependent Drop Down Lists on Many Rows https://www.xelplus.com/excel-dependent-drop-down-every-row/ Thu, 26 Mar 2020 10:00:00 +0000 https://www.xelplus.com/?p=11410 Create multiple dependent drop-down lists in Excel that you can copy to every row. You'll also learn how to exclude the blank cells on the bottom to make sure each list is restricted to the number of categories available.

The post How to Create Excel Dependent Drop Down Lists on Many Rows appeared first on Xelplus - Leila Gharani.

]]> Expandable Conditional Drop Down Lists in Excel https://www.xelplus.com/excel-dynamic-dependent-drop-down-lists-exclude-blanks/ Fri, 20 Jul 2018 07:16:00 +0000 https://www.xelplus.com/?p=10085 Quickly create dynamic drop-down lists in Excel that are dependent on another list. Automatically exclude blank cells and allow the drop-down to expand as new values are added.

The post Expandable Conditional Drop Down Lists in Excel appeared first on Xelplus - Leila Gharani.

]]> Conditional Format Index Match Result in Excel https://www.xelplus.com/conditional-format-index-match-result/ Thu, 18 Jan 2018 07:44:00 +0000 https://www.xelplus.com/?p=11183 Quickly learn how to conditionally format the result of your lookup value inside the original data set. If you conditional formatting formula is not working, it's probably because of incorrect referencing.

The post Conditional Format Index Match Result in Excel appeared first on Xelplus - Leila Gharani.

]]> Extract Unique Items for Dynamic Data Validation Drop-Down List https://www.xelplus.com/extract-unique-items-for-dynamic-data-validation-drop-down-list/ Fri, 05 Jan 2018 14:19:00 +0000 https://www.xelplus.com/?p=11193 Learn how to extract unique items from a list that contains multiple instances of each item, and use this list in a dynamic dropdown so that any time the list expands, your data validation list is updated. The solution will work in any Excel version, no Office 365 required.

The post Extract Unique Items for Dynamic Data Validation Drop-Down List appeared first on Xelplus - Leila Gharani.

]]> Excel Dynamic Chart with Drop-Down https://www.xelplus.com/excel-dynamic-chart-with-drop-down/ Mon, 11 Dec 2017 07:36:00 +0000 https://www.xelplus.com/?p=11238 With these simple steps you can easily create an interactive chart in Excel which will for sure impress your team. Once you learn the basics for dynamic chart ranges, you can create any dynamic graph you need in Excel.

The post Excel Dynamic Chart with Drop-Down appeared first on Xelplus - Leila Gharani.

]]> Lookup Values Across Multiple Worksheets in Excel https://www.xelplus.com/lookup-values-across-multiple-worksheets-excel/ Fri, 17 Nov 2017 07:40:00 +0000 https://www.xelplus.com/?p=11271 In this tutorial, we will address how to lookup values in multiple tabs using a single formula. You will see one method using VLOOKUP and direct worksheet and cell references, and another using INDEX & MATCH and Excel Table names and references. Both approaches rely on the INDIRECT function to return the correct sheet address in a dynamic way.

The post Lookup Values Across Multiple Worksheets in Excel appeared first on Xelplus - Leila Gharani.

]]> Excel Dependent Drop Down List with Tabular Data https://www.xelplus.com/excel-dependent-drop-down-list-tabular-data/ Thu, 09 Nov 2017 19:45:00 +0000 https://www.xelplus.com/?p=11799 How do you create conditional lists without name manager? You can use the offset formula directly in the data validation box. Watch this video to find out how.

The post Excel Dependent Drop Down List with Tabular Data appeared first on Xelplus - Leila Gharani.

]]>