Input: Sample file with base data.
Download sample input files here
Goal: Apply lookup with respect to bank column. In report, column 'amount' should be sum of all the bank entries available.
Hint:
1.Select key range and lookup range as given in sample file.
2.Match criteria will be Bank(lookup table)=Bank(key values)
3.Report all column with function 'SUM'