Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Formula IF/OR statement for multiple item conditions

Topic Labels: Formulas
Solved
Jump to Solution
1049 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Alex_Cristian
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello all,

I’m trying to figure out a clean way of writing a formula for a Lookup table that can hold up to 4 variables at any time (A,B,C,D).

Based on these variables, I want the formula output the following:

IF(Lookup contains: “A or B or C or A,B or A,B,C” - in any given order), output “Inhouse”, but if D is also present, still output “Inhouse”. If only D is present, then output “Foreign”.

Is there a clean way to write this?

Thanks so much in advance!

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

IF(Lookup="D","Foreign","Inhouse")

See Solution in Thread

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

IF(Lookup="D","Foreign","Inhouse")

Wow! This is perfect…thanks a million!