You don't give much away do you?

I presume that if C6 has data you want the formula to test that, then C7,
etc.?

If so, then use

=INDEX(C1:C10,MIN(IF(E2<C1:C10,ROW(C1:C10))))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

just change C1:C 10 to the maximum you will ever need.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Altec101" wrote in
message ...

The data in A1 would look like this: 0:03:00


The formula is working great, it does what it needs to do.
This is the formula:


=IF(E2=Buckets!$C$1,"A",IF(E2=Buckets!$C$2,"B",I F(E2=Buckets!$C$3,"C",IF(
E2=Buckets!$C$4,"D",IF(E2=Buckets!$C$5,"E","NA") ))))


--
Altec101
------------------------------------------------------------------------
Altec101's Profile:
http://www.excelforum.com/member.php...o&userid=34539
View this thread: http://www.excelforum.com/showthread...hreadid=571898