I have a rather large spreadsheet (7500 rows) and need to be able to find the
value of one cell based on if another value is between the values in columns
B and C.
For example, if the value I need to reference is 59216, I want to have the
formula return the value in column E when column B is 59200 and column C is
59300. Is there a way to do this with LOOKUP or some function?

As always, thanks to the contirbutors who make my life much simpler with
their expertise!