Excel - list names from one Sheet based on IDs from another one

I'm totally basic Excel user. I received some data in CSV format that I need to connect. This is what I have (simplified)

Sheet 1: enter image description here List of pages with IDs and other data.

Sheet 2: enter image description here Mapping page to categories one-to-many

Sheet 3: enter image description here List of category names and category IDs

I need a formula that for each row in categories column (sheet1 col C) will add comma-separated names of categories for that page (page ID).

I guess this is very easy for someone with at least medium experience in Excel formulas. Please help.

1 answer

  • answered 2022-01-19 17:32 mark fitzpatrick

    Using your sample, the formula would be:

    =TEXTJOIN( ",", 1, XLOOKUP( FILTER( Sheet2!$B$2:$B$7, Sheet2!$A$2:$A$7=Sheet1!A2 ), Sheet3!$A$2:$A$4, Sheet3!$B$2:$B$4,, 0 ) )
    

    enter image description here

How many English words
do you know?
Test your English vocabulary size, and measure
how many words do you know
Online Test
Powered by Examplum