Merging sheets by common column and rows

Occasional Visitor



I have about 20 country-level data (e.g. GDP, education, life expectancy. ) on 20 different sheets, and I want to merge them on a single sheet by the country variable. I ranked the countries alphabetically to facilitate the merge, but the issue is that data for some indicators are missing for some countries. So I'd like to know if there is any special function shortcut to perform this. My goal is to make only the countries present in all the sheets. I found the VLOOKUP option on a website, but that looked complicated to me. 


Thank you. 

Thank you. 

1 Reply


To my knowledge no, there is no such built-in function which will do such merging at once. That's more job for Power Query, if with functions - VLOOKUP, XLOOKUP and like.