Match Only Once
Input: Sample file with base data.
Download sample input files here
Goal: Apply lookup with respect to bank column. In report, the bank name in key values should match with bank name in lookup table only once.
1.Select key range and lookup range as given in sample file.
2.Select match only once in UI.
3.Match criteria will be Bank(lookup table)=Bank(key values).
4.Report all column.