Find a country in a cell with multiple countries...
We are trying to find a list of countries in one sheet that may be in a cell in a separate sheet. we have used the IF formula with CONTAINS in the criteria and this works if we are looking up a singular reference but not on an entire column. This would be fine if the countries remained static but they will be moving into different waves throughout the program. I hope the screenshots here help tell the story a bit better:
We want to return Yes or No in the Wave 1 cell if the country in the Wave 1 countries sheet is found in the Country cell in the same row:
Screen shot of the table we want the formula to be housed and the result brought back:
Screen shot of the country field from this same table where all of the countries for that record are listed:
Screen shot of the different table that will house of the Wave 1 countries
Value from the formula should be yes since all three are listed in that Country cell for that row:
Thank you all so much for your help
Help Article Resources
Check out the Formula Handbook template!