Hello,

Thank you both for your help. You guys are miracle workers!. I have attached my Excel file and left JBeaucaire's version.
Binishyrio - thank you so much. I don't think I used your version correctly when I plugged it in. Great question - for those that travel within 2 different ranges.

Could the formula in the current file somehow give me a result of "1" or an "x" for those that fall within more than 1 season range so i can filter to these at the end and review them manually? This is great already so if not, then i rather leave at is.

Thank you!
~ Grasshopper in training