excel formula to lookup number and give ext

  • Hello

    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.

  • In D2 copied down:


    To get rid of N/A:


    Ali :)

    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!