Consulting

Results 1 to 3 of 3

Thread: Match values between tabs and insert value from other column

  1. #1
    VBAX Newbie
    Joined
    Dec 2021
    Posts
    2
    Location

    Match values between tabs and insert value from other column

    Hello,
    I have a spreadsheet with two tabs: articles and images. My articles tab has 2 columns: art_id and content, while my images tab has also two columns: img_id and art_id. Each art_id in the images tab can have more rows and img_ids assigned to it (so each article can have multiple images).
    I'd like to have a column on my articles tab where I would have all the img_ids belonging to the proper art_id assigned in the images tab.
    This could be done probably via a Power Query, but that's beyond my skillset. Any help appreciated.
    I attach my demo spreadsheet.
    Attached Files Attached Files

  2. #2
    here is a simple function.
    Attached Files Attached Files

  3. #3
    VBAX Newbie
    Joined
    Dec 2021
    Posts
    2
    Location
    Learning every day...
    Thanks a lot arnelgp!

    Quote Originally Posted by arnelgp View Post
    here is a simple function.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •