SOLVED

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)
Solution

@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