Forum Discussion

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 ...

lat_long.xlsx1.7 MB

Producer_Network_Weighted_w_Coordinates_Subset (1).xlsx12.8 MB

excel

Excel on Mac

Formulas and Functions

office 365

bhushan_z
May 22, 2020
Mrinal1996 pls see attached.
Hope I guess your problem right.
Producer_Network_Weighted_w_Coordinates_Subset (1).xlsx21.1 MB

Riny_van_Eekelen

Platinum Contributor

May 22, 2020

Mrinal1996 Look into the VLOOKUP function, alternatively INDEX combined with MATCH. If you are a recent version of Excel, you may have a look at XLOOKUP. The Excel help screen on my Mac notes the following with regard to XLOOKUP.