| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pull cell contents from one wksh to another if condition is met
Need to pull info from wkst 2, column3 and have it in entered in column 5,
wkst 1 only if contents of column 1 match. Any ideas? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pull cell contents from one wksh to another if condition is met
Hi
In column 5 wkst 1 enter =sumproduct(--(A1=wkst2!A1:A100),wkst2!C1:C100) Formula will pull information from column c if cell a1 is withing the A1 to A100 range in wkst 2 If this helped please click yes "Susan" wrote: Need to pull info from wkst 2, column3 and have it in entered in column 5, wkst 1 only if contents of column 1 match. Any ideas? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pull cell contents from one wksh to another if condition is me
Thanks, helps somewhat. However, there are 1600 rows in wkst 1 and only 215
in wkst 2. I keep getting #ref! error. Any ideas? Thanks, Susan "Eduardo" wrote: Hi In column 5 wkst 1 enter =sumproduct(--(A1=wkst2!A1:A100),wkst2!C1:C100) Formula will pull information from column c if cell a1 is withing the A1 to A100 range in wkst 2 If this helped please click yes "Susan" wrote: Need to pull info from wkst 2, column3 and have it in entered in column 5, wkst 1 only if contents of column 1 match. Any ideas? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pull cell contents from one wksh to another if condition is me
Hi Susan,
the range in the formula has to be the same in both sides, in your case from 1 to 1600 "Susan" wrote: Thanks, helps somewhat. However, there are 1600 rows in wkst 1 and only 215 in wkst 2. I keep getting #ref! error. Any ideas? Thanks, Susan "Eduardo" wrote: Hi In column 5 wkst 1 enter =sumproduct(--(A1=wkst2!A1:A100),wkst2!C1:C100) Formula will pull information from column c if cell a1 is withing the A1 to A100 range in wkst 2 If this helped please click yes "Susan" wrote: Need to pull info from wkst 2, column3 and have it in entered in column 5, wkst 1 only if contents of column 1 match. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I found Row 14 in wksh 2, can I get the value of J14 into wksh 1? | Excel Worksheet Functions | |||
| Clear contents of cells if a condition is met | Excel Worksheet Functions | |||
| change cell contents when pull down menu choices change | Excel Worksheet Functions | |||
| Formula: copy/concatenate cell contents matching condition | Excel Discussion (Misc queries) | |||
| I cannot select a single cell or pull down cell contents | Excel Worksheet Functions | |||
Linear Mode
