When K2 has any value in the first part of the formula other than 71876, it
returns "ADJ" for me.

you'll need to use OR for your conditional tests.
OR(K2={71876,147825,186110,73859,1183639,163773,14 0408,226473})

"Patrick" wrote:

Here is the formula that I'm using:

=IF(K2={71876,147825,186110,73859,1183639,163773,1 40408,226473},"GSA",IF(K2={235842,245561,235823,23 5843,245337,239135,200830},"CNB",IF(K2={683983,245 144,29839,4813,67555,175821,82901,175645,139429,17 5397,131445,979352,113854,972262,174756,218880,335 8},"CB","ADJ")))

When K2 has any of the values listed in the first part of the IF it returns
GSA, like it's supposed to. BUT....if any of the other values listed in the
subsequent parts are in K2 it always list ADJ, like it's not in any of the
other list. I can't get it to return CNB or CB. Any ideas why?