Formula for matching data in multiple cells and returning a true if they all match

[MichelleNeedsHelp]

Hi there,

I'm hoping this is relatively easy, but am not so sure. I'm not great with Excel formulas at all.

I have a massive spreadsheet that I'm trying to automate as much as possible. I have attached a picture.

In column C, it has the Country and Region of the client. There can be multiple jurisdictions that our client is in, but the two main ones are Canada and United States. I would like to populate the columns of H - W automatically using the information that is filled in to columns C - F.

For example, column H would be something along the lines of IF cell C3 = "Canada" AND cell D3 = "True" then Cell H3 = "True"
Another one could be IF cell C6 = "United States" AND cell D6 = "True" AND cell E6="True" then Cell P6 = "True"

There are also exclusions. So for the global, it would need to be something like IF cell C9 contains something other than "Canada" and "United States" then cell W9 = "TRUE"
And IF cell C7 is not equal to or does not contain "Canada" then cell T7 = "True"

I hope this is relatively easy and simple to do and I very, very much appreciate the help!!

 

[awoohaw]

would you be kind enough to post your data using the xl2bb add in (link below) as a mini worksheet? And if that is not possible to post your data as a table.
Your image is extremely tiny and hard to read. It means the forum needs to manually recreate your scenario which is time consuming and can lead to typos which can lead to additional work to correct the errors or misunderstandings. you need not send tons of data, only enough rows to cover your scenario, and you need to sanitize your data if there is personal information in the data.

Thanks in advance.

 

[MichelleNeedsHelp]

Sorry -- I hope this is better. This is a company laptop and I can't download outside software to it. Thank you again!

Country/Region	V3 Affiliations	Paid for premium templates?	Admin.us	Include Tag	V3Aff_CA_reg INCLUDE	V3Aff_CA_gov INCLUDE	V3Aff_CA_premium INCLUDE	V3Aff_USA_reg INCLUDE
					Canada + V3	Canada + V3	Canada + V3 + Premium	US + V3 +
Canada	TRUE​			#CALC!​
United States	TRUE​			V3Aff_USA_reg INCLUDE V2Aff_CA_gov EXCLUDE V2Aff_USA_reg EXCLUDE V2Aff_USA_premium INCLUDE USA_premium INCLUDE CA_gov EXCLUDE CA_reg EXCLUDE				TRUE​
Canada	TRUE​			V2Aff_CA_premium INCLUDE CA_premium INCLUDE
Canada India United States	TRUE​			V2Aff_CA_premium INCLUDE CA_premium INCLUDE
United States	TRUE​	TRUE​		V2Aff_USA_premium INCLUDE USA_premium INCLUDE CA_gov EXCLUDE CA_reg EXCLUDE
Canada International United States	TRUE​			V2Aff_CA_premium INCLUDE V2Aff_USA_premium INCLUDE USA_premium INCLUDE CA_premium INCLUDE
Canada International United States	TRUE​			V2Aff_CA_premium INCLUDE CA_premium INCLUDE
Canada United States	TRUE​	TRUE​		V3Aff_CA_premium INCLUDE CA_premium INCLUDE			TRUE​
United States	TRUE​			V2Aff_CA_reg EXCLUDE V2Aff_CA_gov EXCLUDE CA_gov EXCLUDE CA_reg EXCLUDE