•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Multi criteria Xlookup efficiency problem
I'm using an Xlookup with multiple criteria.
For now I'm using: Xlookup (A1&B1, E:E&F:F, G:G)
This is slowing the file down since I'm using variations of this formula in multiple columns (with 4 or 5 criteria in some columns) and I have ~ 150k rows or so.
Any way to make this more efficient?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#natural language processing for spreadsheets
#AI formula generation techniques
#generative AI for data analysis
#Excel compatibility
#Xlookup
#multi criteria
#Excel
#efficiency
#formula
#efficiency problem
#criteria
#rows
#performance
#columns
#data
#slow
#A1&B1