Multiple values in a sigle cell, and validation

[Ilya Baimetov]

My worksheet represents a list of entities E1, anb each E1 can have multiple of other entities E2 associated withit. The most straight-forward way to do it would be to have multiple values in cell - something like {e21, e22, e23, e24}. Te problem I have is validation - I want to validate user's input so that e2x can only be one of the E2 entities defined in another worksheet. So far, I was nto able to come up with validation formula that validates an array of values

- Ily

 

[Dave Peterson]

I'm not sure if I understand, but you may want to look at Debra Dalgleish's site
where she explains how to use data|validation where one value is dependent on
another.

http://www.contextures.com/xlDataVal02.html