Question related to return duplicate value

Super Contributor

Hello Everyone, 

Tried the formula and it works for FIRST NAME

like - 

Screenshot (135).png


But when i have done autofill, i got same value

like - 

Screenshot (136).png


So what should i write formula to return all values and it should be dynamic?


Please help..???


Here is a attached file...

2 Replies
best response confirmed by Zan (Super Contributor)

@Zan You should index the entire Data range and add a MATCH to find the correct column number. See attached.


Very thank you so so much sir