pulling data
in [General]
|
Prev: Conditional formatting using part of the cells contents
Next: Selecting specific cells in a column using countif
From: Norm on 27 Apr 2010 13:49 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
From: Don Guillett on 27 Apr 2010 14:00 try =sumproduct((s1!a2:a22=a2)*(s1!b2:b22=b2)*s1!c2:c22) -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett(a)gmail.com "Norm" <Norm(a)discussions.microsoft.com> wrote in message news:A40C8E08-721F-47BB-A73C-458AC5149465(a)microsoft.com... > 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 >
From: Jim Thomlinson on 27 Apr 2010 14:38 Will there only be a single match or could the inputs on sheet 2 match to multiple rows on sheet1. If there are multiple matches then what? -- HTH... Jim Thomlinson "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 >
From: Norm on 27 Apr 2010 15:09
No the date and the store number in A & B on SHEET 1 will be unique and used once on SHEET 2 "Jim Thomlinson" wrote: > Will there only be a single match or could the inputs on sheet 2 match to > multiple rows on sheet1. If there are multiple matches then what? > -- > HTH... > > Jim Thomlinson > > > "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 > > |