I'm working on a database consisting of a data sheet and a dashboard. For the dashboard, I would like to have a grid looking table to show the various specifications of each unit. Instead of slicers, I would like to use formulas and am trying to use the Index Match formula, which I am not very familiar with.
The formula currently drafted does not return any result:
=INDEX(Data!$A$2:$AQ$45,MATCH(Dashboard!$B$6,Data!$E$2:$E$45))
Can you please help me identify what is wrong with the above formula?
Thank you for your help.
Bookmarks