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
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
      • Subodh_Tiwari_sktneer's avatar
        Subodh_Tiwari_sktneer
        Silver Contributor
        Dec 12, 2019

        mutip 

         

        In VLookup function, the lookup value should be in the first column in the table_array which is not the case with the data. The lookup value ID# exists in column C and you want to fetch the Names which are in column A, therefore VLookup will not work in this case.

         

        Though for fetching values from Comp. Column D, you may use VLookup formula like this...

        =VLOOKUP(J2,C:D,2,FALSE)

        I have placed the above formula in column L for your reference.

        The above formula works because the lookup value J2 exists in the first column of the table_array C:D and it is fetching the values from a column which is right to the lookup column.

         

        If your data is arranged like what is showed on the VLookup Sheet (redTab), you may use the VLookup function without any issue.

         

        There is nothing wrong in learning about Index/Match function, they are more flexible and easy to implement once you learn about how to use them.

         

         

         

Resources