•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Avid Xlookup user forced to used Index Match for the first time
Hey guys, making this post to say that some formulas are still useful despite getting hate on here. I’ve started using excel 3 years ago and I’ve only had to use xlookup for my look ups but I just ran into a situation where xlookup wasn’t working and I had to use index match. Damn this formula combo is really good and I would recommend learning it if you haven’t already
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#AI formula generation techniques
#machine learning in spreadsheet applications
#formula generator
#real-time data collaboration
#real-time collaboration
#xlookup
#index match
#excel
#formulas
#look up
#combo
#learning
#useful
#good