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.

Hint:

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.