pulling from one sheet to another

[Norm]

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

 

[Pete_UK]

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

 

[Norm]

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

 

[Terry Cano]

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