Forum Discussion

mutip's avatar
mutip
Copper Contributor
Dec 12, 2019

vlookup problem

i would like to get the names corresponding to id numbers by using vlookup function 

excel

6 Replies

  • Subodh_Tiwari_sktneer's avatar
    Subodh_Tiwari_sktneer
    Silver Contributor
    Dec 12, 2019

    mutip 

    If you were talking about getting names in column H and Comp. in Column K, please try this...

     

    In H2

    =IFERROR(INDEX(A:A,MATCH(G2,C:C,0)),"")

    and then copy it down.

     

    In K2

    =IFERROR(INDEX(D:D,MATCH(J2,C:C,0)),"")

    and then copy it down.

     

     

    • mutip's avatar
      mutip
      Copper Contributor
      Dec 12, 2019

      Subodh_Tiwari_sktneer 

       

      thanks for help

      but i am a new user for excel i am now using vlookup function to get data

      can you send formula with only vlookup function  excluding iferror or index i am not familiar with these functions yet

      • mutip's avatar
        mutip
        Copper Contributor
        Dec 12, 2019
        thanks for help

        but i am a new user for excel i am now using vlookup function to get data

        can you send formula with only vlookup function excluding iferror or index i am not familiar with these functions yet
        and why i have to shift column b to a

Resources