Max,
I am quite interested in your suggestion for using in another part of the
workbook. I have tried it out and it almost worked for me.
I say almost because when I deleted a cell in colC the result of the formula
in colE shifted up one cell instead of staying where it should be. What this
has meant is the values of colC and colE are nolonger on the same row. Maybe
this is meant to work this way because the dropdown list is working as you
intended it to do. One other thing I noticed is the error #NUM! on in some
cells at the bottom of colE where there is nothing to calculate in some
cells in colC.

Pat

"Max" wrote in message
...
Put in E77:

=INDEX($C$77:$C$2000,MATCH(SMALL($C$77:$C$2000,ROW S($A$1:A1)),$C$77:$C$2000,
0))

Sorry, a correction to the formula above:

Put in E77:
=INDEX($C$77:$C$2000,MATCH(SMALL($D$77:$D$2000,ROW S($A$1:A1)),$D$77:$D$2000,
0))

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----