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

.