Can I use an ifs statement to create the following query? If a1=x or y or z do this, if a1= a or b or c do that

[mark the excel novice]

Hi,

So my question is if a1 = x or y or z then take the value from c1, if a1 = a or b or c take the value from c2

I know I can do something similar to this way:

IFS( A1="x",C1, A1="a",C2)

However, as I add more and more options it becomes a long string

IFS( A1="x",C1, A1="y",C1,A1="z",C1,A1="a",C2,A1="b",C2,A1="c",C2)

I want to be able to say x,y or z = C1, a,b, or c = C2 and be able to just add d,e,f,g,h,i,j,k etc

Is that possible?

 

[Fluff]

How about

=if(or(a1={"x","y","z"}),c1,c2)

 

[mark the excel novice]

How about

=if(or(a1={"x","y","z"}),c1,c2)

Yep, that's worked for me. Thank you so much!

 

[Fluff]

You're welcome & thanks for the feedback.