I don't understand the question. How do 59200 & 59300 relate to your lookup
value of 59216?

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"cursednomore" wrote:

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!