At times It can be much easier to just have two lists that are not joined as lookup columns. I might clear away them Individually and use it as follows. ISTEXT() will not exist in almost any language I have worked with - ordinarily any numeric or day benefit might https://otekworld.com/collections/extension-board