Hello,I'm wondering if anyone has any recommendations on how to achieve the use case below. I've seen VLOOKUP scripts and I've also seen automations, but not sure which would be easier given the criteria.Table A has each Product and State pair listed...
Thanks for your response. If I add the Product columns to the States table, how do I go about only pulling back the Status field for that particular Product/State combo? I'm struggling with the fact that in Excel the formula can be changed for each r...
Hello,Thanks for the ideas but I'm not sure that either option will work for me. When I create the pivot table, I can only get a count of the statuses and not display the actual value.For the States table, there are already several columns in that ta...
