Nested IF OR AND string

Rick Girard

I am looking to combine 2 variables supported by an AND statement to look for matches and then result in an output

1. REGION
2. AREA
3. Owner (output on match)

=IF(OR([::IMPACTED REGION(S)]@row = "US", [::IMPACTED REGION(S)]@row = "CAD", AND([::IMPACTED FUNCTIONAL AREA(S)]@row = "Insurance", [::IMPACTED FUNCTIONAL AREA(S)]@row = "Sales"), [=IMPACTED & RESPONSIBLE RISK OWNER(S)]@row, "NoName"))

I want to look for REGION name US or CAD and the AREA name Insurance or Sales. if either US or CAD are in the REGION field AND if either Insurance or Sales are in the AREA Field, an Owner named cell out be the match.

How close or far am i from getting this right? I am getting ? I get Unparsed Error or Incorrect Argument right now.

thanks!

Rick Girard

Rick Girard

Hello Amanda

the output im looking for is to match a name to the Region and Area they are assigned.

the 3 columns would be:

Region - Area - Name

US - HR - Jane

CAD - Marketing - Mark

LATAM - Ops - Jane

APAC - Sales - Mark

so if Region=US or LATAM and Area = HR or LATAM , then Name =Jane.

Many Names have multiple Regions and Areas associated with them so I'm looking to use the AND OR logic to parse out those matches.