Hello,
I have 2 different excel sheets
Product names are listed starting from A2 in both excel sheets. On the B column in second excel sheet from the supplier it lists a numerical value ( stock quantity, next to each product name)
I want to
1. Search through both A column ranges for the matching product names.
2. If the names from my excel sheet match with the second excel sheet from the supplier. I would like the value from the B column next to that name on second sheet to be output on my list.
Solved by X. W. in 24 mins