Does using JOIN with the End Date field that is part of a dependency not work properly?

James Keuning

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?

James Keuning

Ugh. Nevermind. Turns out the 0 matters LOL.

Genevieve P.

Hi @James Keuning

Do you mean the 0 within the MATCH function? In any case, I'm glad you figured it out!

Cheers,

Genevieve