•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Using dropbox selection to populate a cell from a separate sheet within a workbook.
Our take
In this guide, we'll explore how to use a dropdown selection to populate cells with data from a separate sheet within your workbook. If you've faced challenges with VLOOKUP functions, you're not alone. Many users find it tricky to connect dropdowns to specific data points. By leveraging the power of data validation and formula integration, you can streamline your workflow and ensure that selecting a name from your dropdown list automatically fills in the corresponding address. Let’s unlock the potential of your spreadsheet together!
Hey all, sorry to ask such a stupid question, but I cannot get the right thing to happen no matter what I try. Essentially, I want to select a name from a drop down list and have the merged cells below it return an address from a separate sheet in the same workbook. I have tried some different VLOOKUP functions, but I just cannot get them to work for the life of me. I have attached a link to a PDF with some photos of my spreadsheet (I created some templates so I could keep my actual clients anonymous), but the cells in the templates would be the cells in reference on my actual sheets. Any assistance would be greatly appreciated.
Edit: Since I cannot post anything in the main post with a link or photo, nor can I start with asking for help, I hope attempt number three works, and then I will try and respond with a link to a PDF of the spreadsheet in question.
Edit: I figured it out. Thanks everybody, sorry to waste your time because I am an idiot.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- 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]
- Xlookup from another page in Google SheetsHello, I'm a novice user and trying to make a spreadsheet to help with work, using multiple conditions from an order to generate a list of needed parts. I'm getting an error when attempting to reference data from a drop down on another page. I've attached a trimmed down example that I can share without posting work info. https://docs.google.com/spreadsheets/d/1UT6k7b7Sqi0mV6L867CS_jSVQXN15ZyDkHa3gPlTgrg/edit?usp=sharing The real document has more of basically variable, but I think part of the complexity problem is the part numbers I'm trying to generate use the inputs in different ways and in different orders for each part, so I'm trying to make a page for each kind of part data and keep a cleaner UI page. There's probably a cleaner way to do this, that may or may not work with all the actual inputs I need to do, but I'll take any and all advice, I'm just a novice at best. Thank you. submitted by /u/Zestyclose_Silver352 [link] [comments]
- Pulling data when looking at a specific cell?I know its possible to make a drop down menu, but is it possible to make it so that when I select something in the drop down menu and type in a value in the box to the left of the drop down menu, it looks up data from another sheet that Auto fills into to other boxes? I have read about the "LOOKUP" command, but im not sure it does what is want to do. I have posted a pic that hopefully shows what i mean Hope someone can help. submitted by /u/GGS1LENCE [link] [comments]
- Making a fillable form with dropdowns and sections that can be added and moved easily**SEE ATTACHED IMAGE** I am attempting to improve this spreadsheet. I have a decent amount of experience with Excel but I am unfamiliar with the terminology require to describe the exact functions I am attempting to implement. The function of the sheet is to log various statuses and information pertaining to ladders and their inspection status. Each workbook has a header section and a footer section to diffentiate between clients. The sections that detail the individual ladders need to be moveable / re-order more easily, and also be able to insert a blank ladder section for any new ladders that come into service. The reason excel was selected is for access reasons. All of our clients use excel, but if there is an objectively better tool for the job that is part of the Office suite that people can use via the web or with their Office licence then I will consider that. Thank you to everyone who is able to provide some insight into this. https://preview.redd.it/7ln3oocpcjvg1.png?width=1405&format=png&auto=webp&s=584525d55bd27779bd56a9d746b5dcc6dd913c70 submitted by /u/WillowDime [link] [comments]
Tagged with
#financial modeling with spreadsheets#Excel alternatives for data analysis#natural language processing for spreadsheets#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#AI-powered spreadsheet#spreadsheet API integration#rows.com#Excel compatibility#google sheets#real-time data collaboration#real-time collaboration