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

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

      Mrinal1996 

       

      https://www.youtube.com/watch?v=XwL6RpAk8k8

      Go through this video, it will give u fair idea.

       

      Note: This is not my video

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

        Hi bhushan_z .I undertstand the material.But how do I use this concept  when there are two .xlsx files .What is the link between them both?

Resources