I currently have the following formula in column AS to check for certain values in column G.
I need to expand this to first look column AN5 for a YES value, and then look in G5 for one of the criteria within that formula, and if both conditions are met, return a "Yes" in AS5.
AS5=IF(OR(G5={"LU","BE","NL","IT","ES","GB","DE","CZ","SK","FR","IE"}),"Yes","")
I need to expand this to first look column AN5 for a YES value, and then look in G5 for one of the criteria within that formula, and if both conditions are met, return a "Yes" in AS5.