Thank you in advance.

I’ve got a ton of paints for my models. I’ve also got a list of models and the paints needed.
How can I get it so that I can look at a particular model and what paint I need at a glance?

Model in column A (repeated) paints in column B (many) then just filter the whole lot and use the drop down to choose the model.

In theory a 1 (model) to Many (paints) relationship would be better dealt with using a relational database, but I suspect that would be overkill.

Thank you Geoff 🙂 That’s it 🙂