If anyone can even point me in the right direction of something to try, I'll gladly pay:



I have 29,000 reservations in an Excel Spreadsheet - each reservation has a Campsite #, like 115.



Campsites are divided into sections, for instance 1-50 is Green. 50-100 is Blue. Etc.



I need to fill in the Section for each reservation based on the Site #.





There are 29,000 of them, and they are in no particular order.

well, your information was about halfway helpful. you missed out the most important detail: how do you convert a site # to a section?

I used

=CHOOSE(MATCH(A1,{0,99,139,189,209,260,300},1),"a","b","c","d","e","f","g")


Worked wonderfully, closed.