Why didn't it hit even though I searched for "Yamada"? I searched for "Yamada," but it didn't hit. Even though the data should be there, VLOOKUP calmly returns "#N/A." When I investigated the cause, I ...

It is in a table format. The same items are repeated. There is also master data. If so, couldn't it be filled in automatically? This line of thinking itself is natural. However, with application ...