IF "THIS or THIS or THIS" then DOTHIS BUT IF "THIS or THIS or THIS" AND ALSO "THAT" then DOTHAT

[jnrpal]

Sorry if the title is confusing, I think i might be going crazy by now haha.

Trying to look at two columns of data and output accordingly.

to simplify it lets say COLUMN A can have data input either (1,2,3) or any combination of them ie. 12, 123, 13, 23
COLUMN B can have data input (1, 2, 3, 4, 5) and certain combinations of them (combinations not relevant for this question).

I want COLUMN C to output a word depending on what COLUMN A says.
example 1 = left, 2= center, 3= right , 12 =left and center, 123 = left, center and right.
so If COLUMN A has (1 OR 12 OR 123 OR 13) then it outputs LEFT in that column. (there's also two more columns to capture center and right but again can just copy the result of this for them)
BUT
If COLUMN A has (1 OR 12 OR 123 OR 13) AND COLUMN B has the value of 1 then i want COLUMN C to output the word CRITICAL.

I can copy my formulas i have so far if that helps, appreciate any and all help, I'm pulling my hair out and I've read so much online to no avail.

Thankyou

 

[mole999]

Re: I'm going crazy....IF "THIS or THIS or THIS" then DOTHIS BUT IF "THIS or THIS or THIS" AND ALSO "THAT" then DOTHAT. Can this work?

that would suit a lookup table

Excel Workbook
	A	B	C	D	E
1	1	left		2	centre
2	2	centre
3	3	right
4	12	left centre
5	13	left right
6	23	centre right
7	123	left centre right
Sheet1