View Full Version : [SOLVED:] Insert names found according row .
Dan Flaiban
04-06-2023, 10:12 AM
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
04-06-2023, 11:19 AM
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
04-06-2023, 01:43 PM
Expected30712
p45cal
04-06-2023, 03:18 PM
=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
04-10-2023, 10:07 AM
Amazing !!!
Thanks a lot !!!
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.