Hi
think you mean ascending? Two ways:
1. Resort the list :-)
2. A little bit kludgy but give it a try

=IF(ISNA(MATCH(B1,A1:A100,0)),INDEX(A1:A100,MATCH( B1;A1:A100,1)+1),INDE
X(A1:A100,MATCH(B1,A1:A100,0)))



--
Regards
Frank Kabel
Frankfurt, Germany

How do I do this if it is in ASENDAIANG order?


---
Message posted from http://www.ExcelForum.com/