Forum Discussion

Mrinal1996's avatar
Mrinal1996
Copper Contributor
May 22, 2020
Solved

A doubt in merging two Excel Sheets

Hi ,      So I have been facing trouble in merging two Excel sheets. I have two sheets, which are lat_long.xlsx and Producer_Network_Weighted_w_Coordinates_Subset(1).xlsx. I need to incorporate the ...
excel
Excel on Mac
Formulas and Functions
office 365
  • Mrinal1996's avatar
    Mrinal1996
    Copper Contributor
    May 22, 2020

    hi bhushan_z .This is exactly what. I wanted to do. May I know how you came about this problem? What formula did you use

    • bhushan_z's avatar
      bhushan_z
      Iron Contributor
      May 22, 2020

      Mrinal1996 

      I used VLOOKUP function.

       

      Other similar functions:
      LOOKUP
      HLOOKUP
      XLOOKUP
      MATCH along with INDEX

      • Mrinal1996's avatar
        Mrinal1996
        Copper Contributor
        May 23, 2020

        Hey bhushan_z .This sounds great! May I know the exact algorithm you used by using  the VLOOKUP function ?What did the VLOOKUP function contain ?

        Hoping to hear from you.

        Regards,

        Mrinal Subash

Resources