AmyL - profile

AmyL · Feb 17, 2023

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...

AmyL · Feb 19, 2023

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...

AmyL · Feb 18, 2023

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...

User Statistics

User Activity

VLOOKUP without a script

Re: VLOOKUP without a script

Re: VLOOKUP without a script