I want to compare rate in column FYP and column APPLAN from file Input with file ConfigRate as below.
Condition comparing
- check data in column FYP and column APPLAN
If data in column APPLAN in input file = Column Campaign in file config → compare rate in column C in file Config.
But if column APPLAN not match in column Campaign in file config → cpompare rate in column D
Example row 2 in file Input → FYP = 750,000 and APPLAN = BU03—> match in file ConfigRate → Rate 750,000 = Bag20
Write output in column Bag and write column Amount =1
and count amount in each Channel in sheet Summary as below.
- remark : I don’t want to fix column name in code —> I want to use file config to pass column name , column index as below.
Please guide me about it.
Config.xlsx (12.3 KB)
ConfigRate.xlsx (19.3 KB)
Input (9).xlsx (452.5 KB)