cell reference to last item in a list

How do I create a formula that will give me the last or
first cell in a column that contains a particular value -
for instance if my column is

A1: X
A2: Y
A3: Y
A4: Z

then what formulas will give me the results A2 or A3
for "Y"

Thx
Lee

Have a look in HELP index for MATCH. Read the different 1, -1, 0

--
Don Guillett
SalesAid Software
donaldb@281.com
"Lee" <lee.herring@bankofamerica.com> wrote in message
news:279601c50961$5ee0ddc0$a501280a@phx.gbl...
> How do I create a formula that will give me the last or
> first cell in a column that contains a particular value -
> for instance if my column is
>
> A1: X
> A2: Y
> A3: Y
> A4: Z
>
> then what formulas will give me the results A2 or A3
> for "Y"
>
> Thx
> Lee