Add Column From Key Range

Input: Sample file with base data.

Download sample input files here

Goal: Apply lookup with respect to bank column. In report, the column reported should be Company Name,Bank Name and Branch Area.


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 Company,Bank and Custom column with its name Branch area (the reference for the custom column should be first cell of branch area column)