Generate A List Joining Two Other Lists Based On Cell Input

Are you using Excel 2016 for this?

I have the Office 365 version. I will update my profile to say that now that it's incorrect.

OK, so the attached uses PowerQuery to create the languages known list (in green).

As you understand querying, you should be OK with this, but if not, I can talk you through. Essentially I used your tables to create a list of names and languages, then merged this with the chosen names in order to create the filtered list.

Update the choose names list and then click on Refresh All on the Data ribbon to see it in action.

Excel 2016 (Windows) 32 bit

	C	D	E
24	Choose Names:		Languages Known:
25	Shrubburum		Dwarvish
26	Raul		Elvish
27	Bogrim Steelbelly		Gnomish
28	Judd		Orc
29	Blaise		Primordial
30	Aloket		Sylvan

Sheet: Problem

Yes, of course. However, I'm running short of time now (it's early Saturday evening here), so would you mind if I do it tomorrow morning?

So, I am going offline very shortly, but I will post instructions for you when I get up tomorrow.

Running a bit late on this, but about to look at it now.

Here we go. Using the original file attached at the start of the thread, follow these steps to recreate the attachment.

1. First load the three blue tables to connection only, naming them Lang, Char and LangCharID by editing the Name property to the right of the PQ window.

To do this, with one of the cells in the table selected, go to Data > From Table/Range.
Next find the Close & Load button at the left end of the ribbon in the PQ editor and select Cloase & Load To ... from its drop-down - select Connection Only.
Repeat for the other two tables.

2. On the Data ribbon, Get Data > Combine Queries > Merge.

Choose LangCharID in the top box and Char in the bottom box.
Click on the character ID columns in each (they will turn green) and OK.

3. Using the double-headed arrow at the top of the Char column, select just the Character Names column and deselect the box bottom left of the dialog - click OK.

Now click on the Merge Queries icon in the ribbon and select the Lang query in the bottom box.
This time select the language ID columns in the two queries and OK.
Again using the double-headed arrow, expand the Lang column selecting just the language name and deselecting the little box bottom left - OK.
Select and remove the two ID columns, name the query LanguagesKnown, then close and load to connection only.

4. Now we need to create the lookup list.

Copy and paste the first three names from the character list to cells to C24:C26.
With these three cells selected, choose Insert > Table - deselect My Table has Headers and click OK.
Change the column header to read "Choose characters:", then with a cell in the table selected, load the table into PQ in the same way as before.
Name the query CharFilter and close and load to connection.

5. Finally, we need to create the results table.

n the Data ribbon, Get Data > Combine Queries > Merge.
Select CharFilter at the top and LanguagesKnown at the bottom - the order is important.
Match the two tables on Choose Characters and Character_Names - OK.
Expand the table as before, choosing just the Language_Name column and deselecting that little box - OK.
Delete the character names column.
Right-click the remaining column and choose Remove Duplicates, then use the downward arrow to sort in ascending order.
Rename the column "Languages Known:".
Name the query GroupLangs, then close and load to Existing Worksheet - select E24 as the destination cell.

That's it. Now all you have to do is change and/or add names to the sepection table and click Refresh All on the Data ribbon.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Thanks for the rep.