Occasionally It is really much easier to just have 2 lists that are not joined as lookup columns. I might eliminate them personally and use it as follows. ISTEXT() does not exist in any language I've worked with - commonly any numeric or date price could be transformed to textual https://otekworld.com/collections/extension-board