Filter Inline List based on values on a host sheet

Unfortunately we cannot compare 2 dynamic values in a filter or if/then column, although it has been requested several times. This would be best achieved with relations, but due to your use of greater than and less than compares, this further complicates things.

I would recommend reading up on these methods to get a better idea of how to do this. You’ll will most likely need to think of your logic backwards. Create relations, lookups, it/thens, etc. in the items sheet to pull in the selected value. Then create the proper relations in the selection sheet to match up. I hope this helps.: