How to build Mapping Vlook with Count Formula

[Learner09]

Hi All,

I am trying to build a count formula by using mapping and current data sets. Please see the attached file for details and provide assistance.

Thanks, 

[Jean-Balteryx · Accepted solution]

Hi @Learner09 ,

Here is an example workflow ! So basically a join between bot sheets allows you to know which ID are in Data and not in mapping. For those, you had a count of 1 and for ID in both sheets you had a count of 0 then using a union you assemble back the data.

Cheers,

Jean-Baptiste

[Learner09]

Thanks Jean!