From: Norm on
I am having trouble pulling data from one sheet to another:

SHEET 1
A B C D E
4/21/2010 34287 74 3 4
4/21/2010 39210 90 1 4
4/21/2010 13969 56 3 3
4/21/2010 33369 45 2 2

SHEET 2
A B C D E
04/16/10 13969
04/16/10 39210
04/16/10 34287
04/16/10 33035


I want to pull the data from SHEET 1 column C,D,E .....if A and B match on
both sheets
The data in a columns on sheet 1 is entered manually and changes each day
From: Pete_UK on
You could contatenate column A and B values together in a helper
column on both sheets, and use this to determine an exact match. For
example:

=A1 &"_"& B1

will give you something looking like this in your helper cell:

40289_34287

where the first number is the serial value of the date in A1.

Hope this helps.

Pete

On Apr 27, 4:35 pm, Norm <N...(a)discussions.microsoft.com> wrote:
> I am having trouble pulling data from one sheet to another:
>
> SHEET 1
>       A           B             C             D              E
> 4/21/2010       34287   74      3       4
> 4/21/2010       39210   90      1       4
> 4/21/2010       13969   56      3       3
> 4/21/2010       33369   45      2       2
>
> SHEET 2
>      A            B            C              D              E
> 04/16/10        13969                  
> 04/16/10        39210                  
> 04/16/10        34287                  
> 04/16/10        33035                  
>
> I want to pull the data from SHEET 1 column C,D,E .....if A and B match on
> both sheets
> The data in a columns on sheet 1 is entered manually and changes each day

From: Norm on
I'm not sure I am explaining this right
I want the data from C21 on sheet 1 in a cell on sheet 2 if the A & B column
data matches
SHEET 1 row 21
A B C D E
4/21/2010 34287 74 3 4

SHEET 2 row 20
A B C D E
4/21/2010 34287 74

"Pete_UK" wrote:

> You could contatenate column A and B values together in a helper
> column on both sheets, and use this to determine an exact match. For
> example:
>
> =A1 &"_"& B1
>
> will give you something looking like this in your helper cell:
>
> 40289_34287
>
> where the first number is the serial value of the date in A1.
>
> Hope this helps.
>
> Pete
>
> On Apr 27, 4:35 pm, Norm <N...(a)discussions.microsoft.com> wrote:
> > I am having trouble pulling data from one sheet to another:
> >
> > SHEET 1
> > A B C D E
> > 4/21/2010 34287 74 3 4
> > 4/21/2010 39210 90 1 4
> > 4/21/2010 13969 56 3 3
> > 4/21/2010 33369 45 2 2
> >
> > SHEET 2
> > A B C D E
> > 04/16/10 13969
> > 04/16/10 39210
> > 04/16/10 34287
> > 04/16/10 33035
> >
> > I want to pull the data from SHEET 1 column C,D,E .....if A and B match on
> > both sheets
> > The data in a columns on sheet 1 is entered manually and changes each day
>
> .
>
From: Terry Cano on
Sounds like the same sort of thing I can't figure out...
in QP I did a range for data query and criteria that data range and extracted
it to another sheet...can't figure it out in Excel...let me know when you
figure it out
Thanks
"Norm" wrote:

> I'm not sure I am explaining this right
> I want the data from C21 on sheet 1 in a cell on sheet 2 if the A & B column
> data matches
> SHEET 1 row 21
> A B C D E
> 4/21/2010 34287 74 3 4
>
> SHEET 2 row 20
> A B C D E
> 4/21/2010 34287 74
>
> "Pete_UK" wrote:
>
> > You could contatenate column A and B values together in a helper
> > column on both sheets, and use this to determine an exact match. For
> > example:
> >
> > =A1 &"_"& B1
> >
> > will give you something looking like this in your helper cell:
> >
> > 40289_34287
> >
> > where the first number is the serial value of the date in A1.
> >
> > Hope this helps.
> >
> > Pete
> >
> > On Apr 27, 4:35 pm, Norm <N...(a)discussions.microsoft.com> wrote:
> > > I am having trouble pulling data from one sheet to another:
> > >
> > > SHEET 1
> > > A B C D E
> > > 4/21/2010 34287 74 3 4
> > > 4/21/2010 39210 90 1 4
> > > 4/21/2010 13969 56 3 3
> > > 4/21/2010 33369 45 2 2
> > >
> > > SHEET 2
> > > A B C D E
> > > 04/16/10 13969
> > > 04/16/10 39210
> > > 04/16/10 34287
> > > 04/16/10 33035
> > >
> > > I want to pull the data from SHEET 1 column C,D,E .....if A and B match on
> > > both sheets
> > > The data in a columns on sheet 1 is entered manually and changes each day
> >
> > .
> >