•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
Tagged with
#AI formula generation techniques
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#no-code spreadsheet solutions
#vlookup
#formula
#Apple
#stock
#results
#sum
#table
#sheet
#data
#query
#values
#lookup
#item
#duplicate