•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
I think I need Xlookup or index match to find a specific value with multiple criteria in my excel array but it's not working. Any suggestions?
I have a spreadsheet I'm working on for a tree farm. I'm trying to create a formula that returns a value (G49) with the criteria being the specific tree name, the year, and the total trees at the end of the year, but nothing seems to be working across index match and xlookup. Screenshot below. I am using the latest version of windows and Excel. Thank you
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#Excel compatibility
#rows.com
#financial modeling with spreadsheets
#natural language processing for spreadsheets
#AI formula generation techniques
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#generative AI for data analysis
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#Xlookup
#index match
#Excel
#tree farm