•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to find value in one table and then add it to value from second table?
Hello. In Table1 in column "sum" I want to add amount form column "sales" to the amount of "TeamSales" from Table2 but I want formula to only add the same weeks. How can I do that? Tried to use Vlookup but when i copy it to other cells it does not verify weeks.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#AI formula generation techniques
#Excel compatibility
#Excel alternatives for data analysis
#Table1
#Table2
#sum
#sales
#TeamSales
#Vlookup
#formula
#weeks
#amount
#add
#copy
#cells
#column
#value
#verify
#content