Hi there i have attached a file i am working on. I am using columns K:O to run If statements that check the titles of my tables on that page and return "ok" if it finds that title in the list. As you can see my division test works fine and returns the appropriate True/False values. Howver, when i run the same If statements for the countries I get #Value instead of a True/False response. I have checked the formatting and i am not including any numbers. Can anyone tell what is wrong.
The text in the countries and division columns come from another xls file and I am runnign a crosscheck to ensure that all countries and divisions are included. Thanks in advance.