Loop through 2 columns and concatenate the values

Question

Closed. This question needs to be more focused. It is not currently accepting answers.

---

Want to improve this question? Update the question so it focuses on one problem only by editing this post.

Closed 10 months ago.

Workbook 1 Image

Workbook 2 Image after macro

I have a workbook with two sheets. Please check the images attached above.

Worksheet 1:

ABC Min: $100
ABC Total: $150
ABC Avg: $125
BCD Min: $100
BCD Total: $150
BCD Avg: $125

I want a macro to loop through the columns, Concatenate (With $ values) and insert into worksheet 2. Something like this:

ABC "Min: $100 
    Total: $150
    Avg: $125"
BCD "Min: $100 
    Total: $150
    Avg: $125"

Answer 1

You can do something like this, done on 1 sheet, but index and match will work across sheets. Cell E1 is data validation to choose either case, can add more as needed. Cells A4:B9 contain the lookup and the match builds the lookup value.

=INDEX(B$4:B$9,MATCH(E$1&" "&E4,A$4:A$9,0))