I have a spreadsheet that requires me to sort a list of reporting codes from a pivot table into one of eight cost categories. The column to the right of the pivot table is my cost category column, and it has a drop-down with the eight possible answers. There are several hundred possible reporting codes however, and not all of them show up on each pivot table, and not in the same place on the pivot table each month. Also, some show up multiple times.
I currently have to manually select which cost category each reporting code falls into. Is there a way I can set up a list of the reporting codes with the correct cost category for each, and then when I create the pivot table, Excel will find each reporting code in the list, and display its cost category in the proper column?
In the spreadsheet, columns A-E are part of the pivot table.
Any guidance would be greatly appreciated!
