View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default Vlookup, Sort ??

Alternatively, select F16:F17, put in the formula bar:

=IF(ISERROR(SMALL(IF(E16:E20<"",ROW(A1:A5)),ROW(A 1:A5))),"",
INDEX(E16:E20,MATCH(SMALL(IF(E16:E20<"",ROW(A1:A5 )),ROW(A1:A5)),ROW(A1:A5),
0)))

Then array-enter the formula (i.e. press CTRL+SHIFT+ENTER)
instead of just pressing ENTER

F16:F17 would also return the required results
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---