Need a space saving IF OR formula

pzupan

I have a working function to assign a school county to a new entry when a certain institution ID is put into the column. My issue, however, is the complete equation to accomplish this is too long and doesn't fit the last few school districts. I'm checking to see if there is a more elegant way to accomplish this so I can reduce the equation and fit all the districts.

Here it is with just 2 districts:

=IF(OR([Inst ID]@row = 1894, [Inst ID]@row = 1895, [Inst ID]@row = 1896, [Inst ID]@row = 1897), "Baker") + CHAR(10) + IF(OR([Inst ID]@row = 1899, [Inst ID]@row = 1901, [Inst ID]@row = 1898, [Inst ID]@row = 1900), "Benton")

So essentially, if the institution ID is 1894, 1895, 1896 or 1897 the district should be assigned to Baker county, and if the institution ID is 1899, 1901, 1898, or 1900 they should be assigned as Benton county. Again, this functions how it should, but there are too many characters for all the districts to fit in the same column formula. Is there a way to make the formula work so that [InstID@row = doesn't have to be repeated so much?

Leibel S

@pzupan

How many Institution IDs do you have and how many in each county?

Overall suggestion is to make a separate list and have this look up that list (index/Collect or Index/match)

pzupan

https://community.smartsheet.com/discussion/comment/467716#Comment_467716

I have about 200 institution ID's and the number varies by county. I'll look into setting up vlookup