This solution is PERFECT! Not only does it solve the problem, it also
includes information that let me include the formula in my own spreadsheet!

Thank you very much!

"olasa" wrote:


Is this what you're looking for?

The Input list is placed in column A2.
=INDEX(List,MATCH(SMALL(COUNTIF(List,"<="&List),RO WS(A2:$A$2)),COUNTIF(List,"<="&List),0))

I have defined a name (Menu:InsertNameDefine...)
List: =OFFSET(Sheet1!$A$2,0,0,COUNTA(Sheet1!$A$2:$A$1000 0))

Attached zip-file:
http://www.excelforum.com/attachment...tid=3565&stc=1


Ola Sandström


+-------------------------------------------------------------------+
|Filename: Book5.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3565 |
+-------------------------------------------------------------------+

--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=384453