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.

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