I have an Excel 2010 workbook made up of two sheets (Dashboard and Summary) which shows the results from mobile app testing. I'm trying to use INDEX and MATCH in the Dashboard sheet to return percentage values from the Summary sheet.
The idea is to locate the correct % value on the Summary sheet by providing a mobile device name (eg. iPhone 5) and a test result description (eg Pass).
The reason I am using INDEX/MATCH is because the device names may change, or new devices may be added. Therefore, I want to make it as flexible and maintainable as possible.
I've attached a mock-up of the original workbook.