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