Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Dec 14, 2021 07:56 PM
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!
Solved! Go to Solution.
Dec 14, 2021 08:40 PM
Dec 14, 2021 08:40 PM
IF(Lookup="D","Foreign","Inhouse")
Dec 15, 2021 05:58 AM
Wow! This is perfect…thanks a million!