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

Adapting from the suggestion to your earlier post ..
here's one way, using non-array formulas ..

Source range is in E16:E20

Put in F16:
=IF(ROW(A1)2,"",IF(ISERROR(SMALL($G$16:$G$20,ROW( A1))),"",INDEX($E$16:$E$20
,MATCH(SMALL($G$16:$G$20,ROW(A1)),$G$16:$G$20,0))) )

Put in G16: =IF(E16="","",ROW())
Select F16:G16, copy down to G20

F16:F17 will return the required results,
i.e. the topmost 2 numbers other than blanks within E16:E20
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"M.A.Tyler" <Great Lakes State wrote in message
...
Hi Max, It is close to the same question, and I did try to use some
variations of that formula, without success. By the way that did work well
for my earlier problem! This time I don't think I can use the row numbers,

as
they are 16-20. Also I would like to have the entry in the "E" column come
back as the result. Something like this:

"E"
16 102
17
18 100
19 99
20 So the result here would be 102 & 100

However it could look like this:

"E"
16 100
17 89
18 99
19 100
20 98 Here the answer should be 100 & 89.

Any ideas?