I also have a second Series-like column and a Grouped search
BUT
If the series is a child of the original. I use hierarchical
Honor Harrington.Honorverse
The downside is there is only 1 index value (I use the placement in the sub-series)
If the book spans more than two: I simply set the second series to: <Mix of Series> and use my Fav for the primary