Show Matching Items in Excel List

Pick a region from a drop down list, and see a list of employees from that region.

There are no macros in this Excel workbook, just INDEX/MATCH and other Excel formulas.

This video shows how to set up the Excel tables, and the drop down list.
Then, see how to add the formulas, and learn how those formulas work.

Download the free Excel workbook on this page:
https://www.contextures.com/matchingi...

Video Timeline:

00:00 Introduction
01:01 Create 2 Lists
01:26 Named Tables
02:08 Name the Tables
02:48 Named Ranges
03:41 Drop Down List
04:50 Employee Numbers
07:31 Number in Region
08:44 Matching Items List
09:29 Number Formula
11:48 Employee Name Formula
13:47 Get the Workbook

Instructor: Debra Dalgleish, Contextures Inc.
Get Debra's weekly Excel tips: http://www.contextures.com/signup01
More Excel Tips and Tutorials: http://www.contextures.com/tiptech.html
Subscribe to Contextures YouTube: https://www.youtube.com/user/contextu...
#ContexturesExcelTips