•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How do you use vlookup when there are two results?
I have this table on sheet 1.
Name | Code | Stock
Avocado | 111 | 200
Apple | 121 | 300
Banana | 131 | 50
Apple | 122 | 100
In sheet 2, I want to get the stock of "Apple". How am I supposed to write the vlookup formula so it will get me the sum of both apples? When I try with usual vlookup formula, it only gave me the first apple "300"
[link] [comments]
Want to read more?
Check out the full article on the original site