Comma seperated Filter Criteria Issue

I am working on a spreadsheet in excel which looks in a specific cell (L5) for a section, and then it pulls information from another tab using a filter to show that as part of a table. I use the formula below (multiple times to pull different parts of the table) so that I can enter values and do calculations using information the end user enters, as well as with information from the table.

Please Login or Register  to view this content.

At the moment this works if L5 contains one phrase, but ultimately what I would like to be able to do is have L5 contain multiple comma seperated phrases, and then be able to pull each relevant section from the table.

As an example of the layout of the table, it may look something like the below:

Item $/Qty Markup Section
A $100 1.0 1
B $25 1.0 2
C $1 1.35 2
D $1000 1.50 3

What I am trying to achieve as an example is having a comma seperated list, so in L5 I could have 1,2 and it would return A,B & C in the filter, or if I had 2,3 in that comma seperated list the filter would generate the table with B,C & D entries. The issue is that I am having no luck at all getting the formula to work when I have a comma seperated list in L5, does anyone have any idea how this formula above could be amended to be able to return the filter table with all of the items that are referenced in L5?

I had hoped I might be able to work it out but after going around and around in circles including trying CoPilot, I have had no luck at all.

Thanks for your help, I have updated my profile and also uploaded an example spreadsheet.
This is part of a quoting tool I am working on creating, but basically In my example spreadsheet, I am really aiming to be able to pick a comma seperated list from L5 of the Calculator tab, and have the filter pick up every entry from Supportging Information where any of the entries are in the H column, so for example if I have SV,RP in L5 it would show entries that are either SV or RP.

Ideally I would love to do this without a macro / VBA, works on a single entry but not when there are multiple entries.
I am using comma as a delimiter, but I can change that to whatever if it makes life easier.

Cheers

Thanks so much for looking at this, it gives me a great starting point to get it all working now without VBA which is amazing!
I might move those helper cells into the supporting sheet and then I can just hide the whole sheet (less chance of people breaking things)

Supporting Information

A11=CHOOSECOLS(FILTER('Supporting Information'!A2:H100,ISNUMBER(MATCH('Supporting Information'!H2:H100,TEXTSPLIT(Calculator!L5,","),0)),""),1,2,3,4,6,8)