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.