On Wed, 13 Aug 2008 08:23:00 -0700, DebC
wrote:

In an excel spreadsheet as below: Cell A1 = 53.25. I need a formula in cell
B1 that would find where the 53.25 would fall within columns C and D with a
result from column E. As in 53.25 falls between 46 and 55, so the resulting
'3' would be the answer I need in cell B1. Is there such a formula? I'm
sorry I'm not explaining this scenario well, but I would be forever grateful
for any help.

A B C D E
1 53.25 _____ 26 35 1
2 36 45 2
3 46 55 3
4 56 65 4

Given just what you post, all you need is column D:

26
36
46
56

and this formula:

=IF(OR(A1<26,A165),"",MATCH(A1,D1:D4))

--ron