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.


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'