Hi there!
Probably asking a quite dumb question, but:
I have an Excel folder, with different sheets, listing:
-Priority accounts for Global Team
-Priority accounts by country: FR, ES, IT
I know that Global Team has listed priority accounts that are not part of Priority accounts for countries.
I would like to be able to see which Priority accounts for Global team are not included in Priority accounts in Country, by comparing, for each sheet:
Country + Account + Vertical
However, several issues:
-I don't know which formula to use. Thought first about vlookup, but don't think it's going to solve my pb.
-I want to get an error message only if Priority accounts for Global are not in the Country Priority accounts, (and not if Country Priority accounts are not in the Global Priority accounts).
-I need to take into consideration several sheets (one for FR, one for ES, one for IT, etc...). I didn't do it, but it's probably easier to put all data on one sheet, right?
I attached a sample example of sheet.
Does anyone has any insight on how to do this?
Thanks a lot for the help
Bookmarks