I am trying to see if items I have in one list exist in the other. I have created a module with a boolean line item and my idea was to use the formula = IF ISNOTBLANK(FIND('IN3 Vehicle'.anacode, Total Vehicles.anacode)) THEN TRUE ELSE FALSE to find if the values exist in both list. (If it does appear in both list return true) The list items are formatted as numbers. What formula should I use that can allow me to compare the two list without having to line up the list values? (note: i am having a hard time using FINDITEM as well because they do not have a hierarchical relationship)
Thank You!