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:


    =INDEX($A$2:$A$201,MATCH(G2,$B$2:$B$201,0))


    To get rid of N/A:


    =IFERROR(INDEX($A$2:$A$201,MATCH(G2,$B$2:$B$201,0)),"")

    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!