Hi, I am trying to get all the values from rows with VLOOKUP.
I have data which has seller name in merged cell and Product is in differrent rows.For Example: Adam seller has Bananas,Oranges And Lemons...
<tbody>
Seller
Product
Adam
Bananas
Oranges
Lemons
Robert
Apricotes
Lemons...