Formula to filter on two statements

[mcgonma]

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 formula, and if both conditions are met, return a "Yes" in AS5.

 

[jtakw]

Hi,

You can add an AND to your formula:

=IF(AND(AN5="Yes",OR(G5={"LU","BE","NL","IT","ES","GB","DE","CZ","SK","FR","IE"})),"Yes","")

 

[mcgonma]

Perfect! Thank you!

 

[jtakw]

You're welcome.