I'm trying to write a conditional formula that will indicate if the data in a
indiviual cell in column A falls within the range of the data in Columns B
and C. See example data below. There are roughly twenty thousand lines
that I need to search if a particular number falls within the range. Is
there a formula that will capture range of data???



A B C

491987312 491987100 491987199
491987200 491987299
491987300 491987399
491987400 491987499

I've also listed the columns of range numbers on the same sheet as my data.
Could this be on a different sheet? Could the program be written using data
from seperate sheets?