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 WORKBOOK

 

HELPFUL RESOURCE:

How to Combine VLOOKUP and IFERROR to Replace the #N/A Error in Excel

 

 

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn