I want to get customer name from A table, and I use Vlookup in B table. I use Product Code as a Lookup Value. But why it return 0 to several results. In my case, I think It is caused by 1 ID can have many Customer name. If yes, how can I deal with it because I need different customer name from 1 ID. thanks!
Here's my screenshoot
