Pull cell contents from one wksh to another if condition is met

S

Susan

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

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

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

Hi Susan,
the range in the formula has to be the same in both sides, in your case from
1 to 1600
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List all tables, including document structure 0
Receive data in column with pull down 2
Converting a number into a cell reference 2
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Function to pull a single cell from a column into another cell 1
lookup two different variables 0
Adding cells until they are greater than a lookup cell and returning a value 1
Two Condition - search 2

Top