| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling Data | Excel Discussion (Misc queries) | |||
| Pulling data from other wb based on data to populate dropdown list | Excel Discussion (Misc queries) | |||
| Tying to extract all data from a pivot pulling from external data | Excel Discussion (Misc queries) | |||
| Linking two spreadsheet, pulling data from one cell to another, data is being truncated | Excel Worksheet Functions | |||
| pulling data from one sheet and listing selected data in another | Excel Worksheet Functions | |||
Linear Mode
