View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
M.A.Tyler
 
Posts: n/a
Default Vlookup, Sort ??

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?


"Max" wrote:

Essentially, believe you're asking the same question as your previous post
in mid Jan, re - earlier post / responses at: http://tinyurl.com/8tx5h

But you didn't feedback further since ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"M.A.Tyler" <Great Lakes State wrote in message
...
Have a column of from 1 to 5 numbers, I would like to use only the first

two.
Numbers are located in E16:E20. When I say first two, the two closest to

the
top of my column, which starts at E16.

Hoping for help!

Thanks in advance!