pulling from one sheet to another
 

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

pulling from one sheet to another
 

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 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

pulling from one sheet to another
 

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 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

.