Does using JOIN with the End Date field that is part of a dependency not work properly?
I am trying to MATCH on two fields, so I am using JOIN to make one field.
The joined fields in my reference sheet are 1. a text field and 2. the END date field. When I MATCH to that JOINed field, I get #NO MATCH. But if I copy and paste that JOINed field into another field, I do get a match.
Is that END date causing this problem?
Help Article Resources
Check out the Formula Handbook template!