•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Replacing an xlookup with a better way? Database?
Our take
Tired of the limitations of XLOOKUP for managing your ever-evolving store details? It’s time to consider a more sophisticated solution that can adapt to your dynamic data needs. Using a database can streamline your workflow, allowing for seamless updates to store information like square footage and opening dates without the hassle of repeated formulas. By transitioning to a user-friendly database system, you’ll not only enhance efficiency but also empower yourself to keep your data current and accessible.
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?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Trying to build an Excel ‘database search’ that opens another file to the right row — possible?”So I have this mini project that I wanted to do. I genuinely wanted to help my co-workers with their databases (or data banking as they say). The goal is to create an excel file wherein when they could search for a person using either an ID or name and they could click something like a link or a button and then it'll open another excel file/s and get to the exact row based on the ID and/or name. The files that'll be opened could vary so I was thinking of buttons that opens the file and highlight or locates the exact row based on the ID. I'm not sure if this could be done. I wanted to give this a try but I just don't know the term to search for. Is this doable? Any ideas how or if there are other suggestions? I'm not an expert at Excel but maybe above average. I know a little bit of VBA but I'm willing to learn. Hope someone could help to search for the right term. submitted by /u/richako [link] [comments]
- Change contents of cells based on a drop downSo, I'm trying to generate a spreadsheet to make the forms we use in the office to issue keys. When people are given an apartment, we have a sheet with all the key numbers on it, and then they sign for it. At the moment, we've got 22 different PDFs and Word documents, and it doesn't work. So, what I want to do is this. I've built the template in Excel and created a Reference sheet which will have all the numbers in it. What I am trying to do is set it up so that when you use the Apartment number from a dropdown, it populates with all the key numbers. This sounds like it should be easy to do, but my Excel brain is broken. Advice would be much appreciated! submitted by /u/Hot_Syrup_1774 [link] [comments]
- I’ve been using Excel more lately and I’m trying to understand some of its more advanced features without making everything overly complicatedWhen working with data that has multiple conditions or needs to update automatically, what are the most efficient functions or tools to use? for example, is it better to rely on formulas like XLOOKUP and FILTER, or are there built in tools that handle this more cleanly? Also, how does excel handle performance when formulas start getting longer or more complex? Is there a point where using too many formulas slows things down significantly? What are the best built-in features in Excel for handling complex data in a simple way? submitted by /u/icepix [link] [comments]
- how to hide xlookup if there is nothing to look upHello Everyone I built a file to help my dad with costing for his recipe's. On one sheet i put all his ingredients and their costs. Then a separate sheet for all his recipes. this way when he updates an ingredient cost, it updates all the recipes that uses that ingredient. Now I used xlookup to get the prices from the ingredients sheet. is there a way to hide the xlookup if there is no ingredient entered in a row? The reason i ask is because if i add the xlookup to lets say 100 rows and he enters lets say 10 ingredients, if he has to print the page, it will print 100 lines and multiple pages instead of 1 or 2 pages submitted by /u/South-Result-2672 [link] [comments]
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