Forum Discussion
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 latitude and longitude value of the former into the latter with respect to the Company Name ,which is present in the lat_long.xlsx and Source , which is present in the Producer_Network_Weighted_w_Coordinates_Subset(1).xlsx
Mrinal1996 pls see attached.
Hope I guess your problem right.
9 Replies
- bhushan_zIron Contributor
Mrinal1996 pls see attached.
Hope I guess your problem right.
- Mrinal1996Copper Contributor
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_zIron Contributor
I used VLOOKUP function.
Other similar functions:
LOOKUP
HLOOKUP
XLOOKUP
MATCH along with INDEX
- Riny_van_EekelenPlatinum Contributor
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.