title: Conditional IF statement for mixed range of inputs (not in chronological order)
body: <p>My situation is this: I'm trying to create a conditional IF statement that tests whether a cell falls within a mixed range of data and outputs a specific result. To be more specific, I want to search a range of serial numbers that correlate to a specific model year, however the serial numbers are not in numerical order (i.e. SN's 202-235, 241, 247-255 are model year 2015, and SN's 257, 201, 259-269 are model year 2016). Is there a way to create this?</p>