Which Function To Use

[Nick]

Hello,

I am running Excel 2003. Im trying to accomplish a lookup.

On sheet 1, in column A, I have values such as: A, B, C, D. These values
repeat themselves. A small example:

a date place
b date place
b date place
a date place
c date place

On my second sheet, we'll call it the "a" sheet, I want this sheet to
basically list only the cells that had "a" in column A from sheet 1. So I
would want to see on this sheet (using above example)

a date place
a date place

I've tried using VLOOKUP, but am getting strange results. I think it's
because the values repeat themelves ..but Im not sure.

Any help is greatly appreciated.

[Don Guillett]

why not use
data>filter>autofilter>filter for a>copy

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Nick" <Nick@discussions.microsoft.com> wrote in message
news:10C3A240-DBB8-45EC-97AA-722051CD80A7@microsoft.com...
> Hello,
>
> I am running Excel 2003. Im trying to accomplish a lookup.
>
> On sheet 1, in column A, I have values such as: A, B, C, D. These values
> repeat themselves. A small example:
>
> a date place
> b date place
> b date place
> a date place
> c date place
>
> On my second sheet, we'll call it the "a" sheet, I want this sheet to
> basically list only the cells that had "a" in column A from sheet 1. So I
> would want to see on this sheet (using above example)
>
> a date place
> a date place
>
> I've tried using VLOOKUP, but am getting strange results. I think it's
> because the values repeat themelves ..but Im not sure.
>
> Any help is greatly appreciated.
>
>

[Nick]

thanks..but that's not going to work for me.

I really need a function that can return the results I need on separate
sheets.

"Don Guillett" wrote:

> why not use
> data>filter>autofilter>filter for a>copy
>
> --
> Don Guillett
> SalesAid Software
> dguillett1@austin.rr.com
> "Nick" <Nick@discussions.microsoft.com> wrote in message
> news:10C3A240-DBB8-45EC-97AA-722051CD80A7@microsoft.com...
> > Hello,
> >
> > I am running Excel 2003. Im trying to accomplish a lookup.
> >
> > On sheet 1, in column A, I have values such as: A, B, C, D. These values
> > repeat themselves. A small example:
> >
> > a date place
> > b date place
> > b date place
> > a date place
> > c date place
> >
> > On my second sheet, we'll call it the "a" sheet, I want this sheet to
> > basically list only the cells that had "a" in column A from sheet 1. So I
> > would want to see on this sheet (using above example)
> >
> > a date place
> > a date place
> >
> > I've tried using VLOOKUP, but am getting strange results. I think it's
> > because the values repeat themelves ..but Im not sure.
> >
> > Any help is greatly appreciated.
> >
> >
>
>
>