•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
XLookup or SUMIF to return updated amounts?
Is it possible to use XLookup to return the updated amount using multiple identifiers? Company number, product number and product name is the only combination that will create a unique identifier. I’ll be refreshing this large data set weekly in another worksheet and need a quick way to pull in and track updated amounts to show a variance summary. Or is there a better formula to use to achieve this?
l
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#rows.com
#AI formula generation techniques
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#Excel compatibility
#large dataset processing
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#formula generator
#enterprise data management
#big data performance
#Excel alternatives
#data analysis tools
#data cleaning solutions
#XLookup
#SUMIF
#updated amount