• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to append multiple [resulted] values into a column/worksheet?

E

Excel_Kid

New Member
How to append multiple resulted values into a column?


Can we use VLOOKUP,INDEX,MATCH,COUNTIF ISNA ISERROR etc formulaes?


Case:

Data in colA of worksheet1 should be compared with data in colB of worksheet2 and if matches retrieve value from colC of worksheet2 and paste result/value in colB of worksheet1. And most importantly for multiple results/values found how to append those values/results to colB of worksheet1?


Here is sample data:


worksheet 1:

colA colB

dp ?


worksheet 2

colB colC

dp 234

mj 334

dj 434

dp 534

ap 634

op 734

dp 834


Expected worksheet1 is,

colA colB

dp 234, 534, 834
 
Have a read of Jive's post towards the bottom of

http://chandoo.org/wp/2008/05/28/how-to-add-a-range-of-cells-in-excel-concat/

That should point you in the right direction
 
You must log in or register to reply here.
Back
Top