If/or or Vlookup

[MermaidNiki]

Hi,
I need another complex if/or statement. I created one that would in theory work, but it has too many arguments. I have a cell that contains IDs for 33 monkeys. Each monkey will be listed as high ranking (h), middle ranking (m), or low ranking (l) in another column. Here is my code with too many arguments:
=IF(OR(J2=“rn”, J2=“tl”, J2=“wj”, J2=“an”, J2=“rj”, J2=“fd”, J2=“zd”, J2=“od”, J2=“id”, J2=“td”, J2=“qd”, J2=“ul”, J2=“uk”, J2=“ql”, J2=“fm”, J2=“ba”, J2=“bp”, J2=“cp”, J2=“aa”, J2=“rp”, J2=“up”, J2=“ak”, J2=“ll”, J2=“mm”, J2=“kn”, J2=“om”, J2=“ej”, J2=“nu”, J2=“qs”, J2=“hs”, J2=“cu”, J2=“fu”, J2=“gs”),”h”,”h”,”m”,”l”,”l”,”h”,”h”,”m”,”m”,”l”,”l”,”h”,”h”,”m”,”l”,” h”,”h”,”m”,”m”,”l”,”l”,”h”,”h”,”m”,”m”,”l”,”l”,”h”,”h”,”m”,”m”,”l”,”l”)

Is there a way to combine these somehow or perhaps a more efficient code? The other identifier I can use is that these monkeys are in 3 different groups and there is a separate column that defines this (R2, R1, and PB). I can list which monkeys are in which group if it helps.

Thank you in advance!

 

[FDibbins]

I would make a small table with codes and rank, then use VLOOKUP. Something like...

	E​	F​	G​	H​	I​	J​
1​	rn	h
2​	tl	h			h	rn
3​	wj	m
4​	an	l
5​	rj	l

I2=VLOOKUP(J2,$E$1:$F$5,2,0)

I obviously did not use all of your codes, so add what you need and adjust the range accordingly

 

[MermaidNiki]

Perfect! Thank you - this did exactly what I needed it to and will help immensely in the future.

I would make a small table with codes and rank, then use VLOOKUP. Something like...

	E​	F​	G​	H​	I​	J​
1​	rn	h
2​	tl	h			h	rn
3​	wj	m
4​	an	l
5​	rj	l

<tbody>
</tbody>

I2=VLOOKUP(J2,$E$1:$F$5,2,0)

I obviously did not use all of your codes, so add what you need and adjust the range accordingly

 

[FDibbins]

Good stuff, happy to help