Dynamic table based off master list that reads through a list of numbers

[cuellar]

Hello all,

I am essentially trying to do what arhansen2008 said in his last comment (sadly wasn't answered).
Searching his name will provide the only thread he/she posted in 2008 (sorry I can't link anything).

Right now the code reads and documents rows with "Series 2, Series1" as one entry, but I want the code to read and document the row in both the "Series 1" and "Series 2" search. Is that possible in excel?

Does anybody have any suggestions on what to do?

Thank you for your time and sorry if this is an easy code fix to the original post (I'm a newbie haha).

[AliGW]

Please post the code and/or workbook here, both of which you are allowed to do as a new member. Nobody is going to go hunting for an old thread to help you - sorry,

[cuellar]

Hi Ali,

Sorry about that; the file should be there now.

Right now the code reads and documents rows with "Series 2, Series1" as one entry, but I want the code to read and document the row in both the "Series 1" and "Series 2" search. Is that possible in excel?

[JeteMc]

This proposed 'Low Tech' solution employs two helper columns (Column 1 and Column 2) on the Master Table sheet.
Note that the helper columns could be hidden for aesthetic purposes.
Column 1 is populated using: =IFERROR(LEFT(D2,SEARCH(",",D2)-1),D2)
Column 2 is populated using: =IFERROR(RIGHT(D2,SEARCH(",",D2)-1),"")
On the Dynamic Table sheet the ISBN column is populated using:

Please Login or Register  to view this content.

The remaining four columns are populated using (dragged across and copied down): =IF($A4="","",INDEX(Table13[Title],MATCH($A4,Table13[[ISBN]:[ISBN]],0)))
The count in cell E1 uses: =SUMPRODUCT(--(B4:B22<>""))
Let us know if you have any questions.