return a cell contents as the result of usiing "small"

I'm trying to return the contents of a cell located above a cell returned
from the "small" function...into the cell located next to the cell which
contains the "small" function....help!

Hi,

How about something like:

=INDEX(A:A,MATCH(SMALL(A1:A100,3),A:A,0)-1)

where A:A is the evaluated column and A1:A100 is the evaluated range

Regards,
KL


"KFEagle" <[email protected]> wrote in message
news:[email protected]...
> I'm trying to return the contents of a cell located above a cell returned
> from the "small" function...into the cell located next to the cell which
> contains the "small" function....help!
>