Jun 20 2019 09:45 AM
Jun 20 2019 10:02 AM
Jun 20 2019 10:14 AM
Jun 20 2019 10:23 AM
Jun 20 2019 10:36 AM
Jun 20 2019 10:36 AM
Jun 20 2019 10:48 AM
That's since you have "Doreen" in A1 and "Doreen " in A3. As variant it could be
=IFERROR(INDEX(TRIM($A$2:$A$4), MATCH(B1&"*",B2:B4,0))=TRIM(A1),"TRUE")
Jun 20 2019 10:52 AM
Jun 20 2019 11:10 AM
You are welcome. Yes, that could be not only spaces but other invisible characters, e.g. if you copy/paste from web. In most cases TRIM() and CLEAN() could help.