Can I be selective using Lookup


Hi, I am doing a podcast production breakdown base and have one sheet that has a column that is Cast, and another multi-select column that is Characters they Play - as a number of the voice over talent will play multiple roles in the one show. In a number of other sheets I’ve created, I’ve linked the cast column and then created a lookup column to get the characters played - however, in some instance I don’t want all of the character they play - just the one that is relevant to the scene I am currently breaking down, if that makes sense? Is there any way (and I doubt it but worth asking) that I can do a multi-select on the lookup so I can choose which relevant character I need for that particular record?

thanks!! Jodie


actually I worked out a work around just by linking different things to other things - all good