Insert names found according row .

[Dan Flaiban]

Hi , Guys.

The code in the sheet works , but I would like come back the result according each row , and if not locate , return "Not Found".

[p45cal]

The code in the sheet works
Works to do what exactly? What is it meant to return?
Your formula looks for the first instance of a value in D, in… column D! It's bound to find it!
Then it returns the data from another list in the same position.

[Dan Flaiban]

Expected30712

[p45cal]

=IFERROR(VLOOKUP(D2,Plan3!$B$2:$B$318,1,0),"Not found in Sheet3")in row 2, copied down, will find an exact match.

For the first match of column D as part of a cell in Plan3 column B then:

=IFERROR(@INDEX(Plan3!B:B,AGGREGATE(15,6,ROW(Plan3!$B$2:$B$318)/ISNUMBER(SEARCH(D2,Plan3!$B$2:$B$318)),1)),"Not found in Sheet3")
For example, if you change cell Plan1!D13 (not found) from ANA LUCIA DE OLIVEIRA DOS SANTOS to just LUCIA you get a match with LUCIANA GONZAGA VIEIRA at cell Plan3!B185.

[Dan Flaiban]

Amazing !!!
Thanks a lot !!!