Find first occurence of specific data in a column.

I would like to be able to run a macro that will find the first occurence in
a column of specified data. There are multiple rows with 1.2005 then more
multiple rows with 2.2005 and so on. I need to locate the first instance of
1.2005, 2.2005 etc and return the value in a cell in the same row but an
adjacent column.
Many thanks.

Since your data is sorted then:
=vlookup(1.2005,A1:B2000,2,False)

in VBA

res = application.Vlookup(1.2005,Range("A1:B2000"),2,False)

--
Regards,
Tom Ogilvy


"Ben" <Ben@discussions.microsoft.com> wrote in message
news:D66AF96B-514C-44EA-A017-7B5DF8811FFC@microsoft.com...
> I would like to be able to run a macro that will find the first occurence
in
> a column of specified data. There are multiple rows with 1.2005 then more
> multiple rows with 2.2005 and so on. I need to locate the first instance
of
> 1.2005, 2.2005 etc and return the value in a cell in the same row but an
> adjacent column.
> Many thanks.

"Ben" <Ben@discussions.microsoft.com> wrote in message
news:D66AF96B-514C-44EA-A017-7B5DF8811FFC@microsoft.com...
>I would like to be able to run a macro that will find the first occurence
>in
> a column of specified data. There are multiple rows with 1.2005 then more
> multiple rows with 2.2005 and so on. I need to locate the first instance
> of
> 1.2005, 2.2005 etc and return the value in a cell in the same row but an
> adjacent column.

just whack:

=if(a2=a1,"It changes here!","")

in cell b2 then copy it down

Problem solved!
Many thanks.

"Tom Ogilvy" wrote:

> Since your data is sorted then:
> =vlookup(1.2005,A1:B2000,2,False)
>
> in VBA
>
> res = application.Vlookup(1.2005,Range("A1:B2000"),2,False)
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Ben" <Ben@discussions.microsoft.com> wrote in message
> news:D66AF96B-514C-44EA-A017-7B5DF8811FFC@microsoft.com...
> > I would like to be able to run a macro that will find the first occurence
> in
> > a column of specified data. There are multiple rows with 1.2005 then more
> > multiple rows with 2.2005 and so on. I need to locate the first instance
> of
> > 1.2005, 2.2005 etc and return the value in a cell in the same row but an
> > adjacent column.
> > Many thanks.
>
>
>