pulling data
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 |
pulling data
try
=sumproduct((s1!a2:a22=a2)*(s1!b2:b22=b2)*s1!c2:c2 2) -- Don Guillett Microsoft MVP Excel SalesAid Software "Norm" wrote in message ... 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 |
pulling data
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 |
pulling data
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 |
All times are GMT +1. The time now is 10:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com