Download Excel Workbook
Table of Contents
INDEX Function with Data Validation
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.
Download workbookIndex_Interactive-List.xlsx
John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.
