Pinterest Pixel

INDEX Function with Data Validation

To make the INDEX function in Excel interactive we can add a Data Validation drop down list.... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

INDEX Function with Data Validation | MyExcelOnline INDEX Function with Data Validation | MyExcelOnline

To make the INDEX function in Excel interactive we can add a Data Validation drop down list.

By referencing the second argument in the INDEX function – the Row Number – to a data validation list, will allow a user to choose the nth position of a list and return their respective metrics.

Say, for example, we had a list of Top 10 customers with their respective Sales and Units sold.  A user can choose a number from the drop down list and return the customer name, their sales and units sold – all with the power of the INDEX function.

See how this is achieved in the below animated gif.

INDEX Function with Data Validation | MyExcelOnline
Download workbookIndex_Interactive-List.xlsx

 

 

 

 

If you like this Excel tip, please share it
INDEX Function with Data Validation | MyExcelOnline INDEX Function with Data Validation | MyExcelOnline

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...