Replace

Input: Sample file with base data.

Download sample input files here

Goal: Setup a workbook formula that pulls the data from the sample file and apply a filter to get all the #NA in currency column and replace it with INR.