Hi,
My main data set has data with country names in column A. I also have separate files for each country.
I can make a separate vlookup table where based on the country names where I have copied the file names which ends in -USA.sxlsx or -UK.xlsx or -RU.xlsx and everything else is same.
How can I have the vlookup or anything else change it based on my main data set containing the country codes?
Bookmarks