Index - match not work correctly

COLUMN A: VANESSAGARCIA


COLUMN D: VANESSAGARCIA

COLUMN D IS THE LOOKUP IN THE MATCH FUNCTION

I did a VANESSAGARCIA
= VANESSAGARCIA
and got TRUE

MY FUNCTION IS =INDEX(A:A,MATCH(D2,A:A,0))

Why did'nt the formula result to TURE on the particular name. I worked on other names.

The INDEX()/MATCH() is working correctly. It's supposed to retrieve the value from the cell.

If you want a TRUE/FALSE result try:

=ISNUMBER(MATCH(D2,A:A,0))