How to shorten formula for multiple OR conditions

[SanjayGMusafir]

Hi Experts
I have this formula that tests multiple OR conditions to give result.

Can we shorten this formula?
Where we don't need to repeatedly write [@Refer]
or
If we can make a list and formula may check that list to test OR condition?

I believe I saw someone using a shorter way to write similar thing on this forum itself but with growing age unable to recall what exactly that was...

=IFS(OR([@Refer]="AKG",[@Refer]="RPG",[@Refer]="MGG",[@Refer]="Ish, Sonepat",[@Refer]="Nidhi, Khanna",[@Refer]="Ankush, LxmNgr",[@Refer]="BHMS",[@Refer]="Billa, Jldr",[@Refer]="Bittoo, Gzb",[@Refer]="BVB",[@Refer]="Chauhan, Asr",[@Refer]="Didi",[@Refer]="Reeta, Gzb",[@Refer]="Ginni, Rhn",[@Refer]="GurpreetS AmbVhr",[@Refer]="Janu",[@Refer]="Jappi, RjrGdn",[@Refer]="Jitender, Jpr",[@Refer]="JoginderS, PVhr",[@Refer]="Jyoti, Takshila",[@Refer]="Monga AshkVhr",[@Refer]="Network 21",[@Refer]="Nightingale, SFA",[@Refer]="Pintoo, MwlNgr",[@Refer]="PPrakash, GH13",[@Refer]="Raju, NMkt",[@Refer]="Rampal Chhatwal",[@Refer]="SatyaP, Pahari",[@Refer]="Shalini, BBPS",[@Refer]="Shaloo, Fbd",[@Refer]="Smita, BBPS",[@Refer]="Ushi, PBgh"),"DND",TRUE,"")

Please help
Thanks a lot

 

[Fluff]

One option is

=IF(OR([@Refer]={"AKG","RPG","MGG","Ish, Sonepat","Nidhi, Khanna","Ankush, LxmNgr","BHMS","Billa, Jldr","Bittoo, Gzb","BVB","Chauhan, Asr","Didi","Reeta, Gzb","Ginni, Rhn","GurpreetS AmbVhr","Janu","Jappi, RjrGdn","Jitender, Jpr","JoginderS, PVhr","Jyoti, Takshila","Monga AshkVhr","Network 21","Nightingale, SFA","Pintoo, MwlNgr","PPrakash, GH13","Raju, NMkt","Rampal Chhatwal","SatyaP, Pahari","Shalini, BBPS","Shaloo, Fbd","Smita, BBPS","Ushi, PBgh"}),"DND","")

But with that amount of options, I would use a lookup table instead.

 

[SanjayGMusafir]

Hi @Fluff

I initially tried this way only. But for some reasons it gave spill error.

I think I shall try LOOKUP as you suggested. It gives me more flexibility that I am looking for.

Thanks again

 

[Fluff]

Glad to help & thanks for the feedback.