Hi all,

I try to map the category in the right hand side of the below picture into the data table on the left. I only need to map one category for each receipt number and there is also a “Both” category for receipts that match both categories.  I tried to use the lookup functions but can’t work that out. Would any one know how can I do this in Excel?

Thank you very much for you help!

​Hi all, I try to map the category in the right hand side of the below picture into the data table on the left. I only need to map one category for each receipt number and there is also a “Both” category for receipts that match both categories.  I tried to use the lookup functions but can’t work that out. Would any one know how can I do this in Excel? Thank you very much for you help!  Read More

​