I currently have the following formula in column AS to check for certain values in column G.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...