Remember Me?

#### Menu

#1
Posted to microsoft.public.excel.worksheet.functions
 external usenet poster Posts: 271
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
 external usenet poster Posts: 2,276
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
 external usenet poster Posts: 271
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
 external usenet poster Posts: 2,276
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?

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post grateful Excel Worksheet Functions 14 September 7th 09 09:23 PM bevchapman Excel Worksheet Functions 2 March 16th 09 04:45 PM jb21 Excel Worksheet Functions 3 November 21st 08 11:34 PM Neil Hutchinson Excel Discussion (Misc queries) 4 September 2nd 08 09:51 AM Carolyn Fahm Excel Worksheet Functions 0 January 24th 06 05:54 PM

All times are GMT +1. The time now is 06:02 AM.

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

# About Us

"It's about Microsoft Excel"