Could someone please give me an excel formula that does the following in the attached excel sheet
1 . Look up value in column G ( source_2_value) and match that value in column B ( source_1_value)
2 . Give the corresponding value from column A ( Source_1_data_field) based on the above matching . The output should be given in Column D ( Mapping_output).
I have attached the excel sheet.