| Home |
| Search |
| Today's Posts |
|
#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? |
| 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 | |||
Threaded Mode
