I have 5 sheets with country data, I want to lookup the country name on 4 separate sheets within 4 separate ranges then take a value from the row and add all those values.
I was getting #NA as a return value so I added IFNA() to each lookup function which results in "To many arguments" error.
here is what the current state looks like
Any help is much appresiated
apologises I should have mentioned the Nation20018 misspelling isn't the issue I misspelt it and never corrected it
EDIT: I'll leave the question open as none of the suggested solutions did the job I did it manually at the end which was tedious, to say the least.