If No Match

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.