Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 22nd 09, 02:43 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 271
Default 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   Report Post  
Old April 22nd 09, 02:55 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 2,276
Default 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   Report Post  
Old April 22nd 09, 03:08 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 271
Default 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   Report Post  
Old April 22nd 09, 03:41 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 2,276
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I found Row 14 in wksh 2, can I get the value of J14 into wksh 1? grateful Excel Worksheet Functions 14 September 7th 09 09:23 PM
Clear contents of cells if a condition is met bevchapman Excel Worksheet Functions 2 March 16th 09 03:45 PM
change cell contents when pull down menu choices change jb21 Excel Worksheet Functions 3 November 21st 08 10:34 PM
Formula: copy/concatenate cell contents matching condition Neil Hutchinson Excel Discussion (Misc queries) 4 September 2nd 08 09:51 AM
I cannot select a single cell or pull down cell contents Carolyn Fahm Excel Worksheet Functions 0 January 24th 06 04:54 PM


All times are GMT +1. The time now is 12:59 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017