I have one spreadsheet with SUBS and information related to non-production. Those non-production subscriptions need to be identified on the other XLS document I have which provides for all the subscriptions (non-production and production) PLUS the consumption aligned to them. I need to identify the non-production subscriptions in the second spreadsheet and remove them to get the overall production consumption.
