S Susan Apr 22, 2009 #1 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?
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?
E Eduardo Apr 22, 2009 #2 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
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
S Susan Apr 22, 2009 #3 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
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
E Eduardo Apr 22, 2009 #4 Hi Susan, the range in the formula has to be the same in both sides, in your case from 1 to 1600
