1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Replacing an xlookup with a better way? Database?

I have this file that I reference all the time for work, and it has like a listing of all our stores, new, old, and projected, and then all their details (sqft, opening date,etc). I would like to stop using xlookups every single time I want to get the store details and use something more sophisticated. Now the details of our stores change quite often, with renovations, closures, etc, so whatever we use next has to be easy for a user to go in and change it. What do you suggest?

submitted by /u/Interesting_Being971
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#real-time data collaboration
#rows.com
#financial modeling with spreadsheets
#Excel compatibility
#xlookup
#database
#store details
#sqft
#opening date
#renovations
#closures
#projected stores
#user-friendly
#data management
#listing
#sophisticated solution
#user input