Hello,
i`m hoping someone can help - this is proving very tricky for me.
I have a conversion chart (or table) - not sure on correct terminology. It shows age as row headers and years service as column headers with data in the rows and columns. In order to look up a specific number you find your age in the row header and years service in the column headers and the follow the row and column until you find the number. For example if your age was 23 and your years service was 6 then the number you lookup is 5 (see image below)
I`m looking for a way to unpick this so that the row header and column header are combinded and the matched number next to it (sorry - this is very confusing!) See below:
Conversion table.JPG
Any help would be much appreciated. I`ve attached a workbook with example table and expected results.
Thanks,
Brendan
Bookmarks