Input: Sample file with base data.
Download sample input files here
Goal: Apply lookup with respect to bank column. In report, get all the entires using all function.
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 colummn with function 'ALL'