Multiple IF + IF(NOT

JDen

Hello and happy New Years to everyone,

I am a little stuck on a formula and would need your help.

Here is my formula: =IF([Column2]@row = "France", IF([Primary Column]@row = "Value 1", "Value A", IF([Primary Column]@row = "Value 2", "Value B", IF([Primary Column]@row = "Value 3", "Value C", IF([Primary Column]@row = "Value 4", " ", IF(NOT([Primary Column]@row = "Value 4", [Primary Column]@row, " ")))))))

What I am trying to do is:

1: If Column 2 = France, I want it to take the value in the primary Column and based on that value, return a different value (translation of the value)

2: If Column 2 is not equal to France, I want it to return the value in the Primary Column, unless the Value = "Value 4", in which case I want it to return blank

Hopefully it's an easy fix. Otherwise I'll use another sheet and vlookup but I'd rather keep it simple.

Thanks in advance,

Julien

Bassam Khalil

Hi @JDen

Hope you are fine, please try the following formula and convert it to a column formula.

=IF(AND([Column2]@row = "France", [Primary Column]@row = "Value 1"), "Value A", IF(AND([Column2]@row = "France", [Primary Column]@row = "Value 2"), "Value B", IF(AND([Column2]@row = "France", [Primary Column]@row = "Value 3"), "Value C", "")))

Bassam Khalil

Hi @JDen

Hope you are fine, please try the following formula and convert it to a column formula.

=IF(AND([Column2]@row = "France", [Primary Column]@row = "Value 1"), "Value A", IF(AND([Column2]@row = "France", [Primary Column]@row = "Value 2"), "Value B", IF(AND([Column2]@row = "France", [Primary Column]@row = "Value 3"), "Value C", "")))

JDen

Brilliant! That worked!

I did have to complete the code for 2nd Condition but it does what I was looking for. Many thanks!!!!

Bassam Khalil

Hi @JDen 

Hope you are fine, i prefer to use Vlookup in your case it will give you more flexibility to manage.

Bassam Khalil

@JDen

You are welcom