Input: Sample file with base data.
Download sample input files here
Goal: Apply lookup. In report column, bank name should be PNB Bank if no match found in bank column.