•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Pulling data when looking at a specific cell?
Our take
If you're looking to streamline data entry in your spreadsheet, you can enhance your dropdown menu functionality. By combining dropdown selections with a cell input, you can create a dynamic system that retrieves data from another sheet. This method can automatically populate related fields based on your input. While the "LOOKUP" command is a valuable tool, it may not fully meet your needs. Exploring functions like "VLOOKUP" or "INDEX-MATCH" could provide the solution you're seeking. Let’s dive into how to make this work effectively.
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.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Drop-down list dependant on two other cellsI have a file where I want a drop-down list in cell D14 that is based on cell D10 and D12. I have looked online and saw lot of videos that are dependant on one cell with the indirect formula, but not two. https://preview.redd.it/ptykf9yzrrwg1.png?width=289&format=png&auto=webp&s=6c0fe00c73c3d45816229bcba5fe2f1733bff083 So for example, if I had this random data and I chose Animal in cell D10, Red in cell D12, I would expect to see 33 and 2 in the drop-down menu of cell D14. Is this possible? The data is in another tab called Data and the info is in column F (F3:F1000) that should appear in the drop-down menu of cell D14. D10 and D12 are both drop-down menus if that matters submitted by /u/LookAtThosePepperoni [link] [comments]
- How do I create dynamic dropdowns that works 2 ways?I have an Order Form sheet set up with a fair bit of code in the background. Part of the Form has order lines with headers of Code, Category and Product Description. I have a separate Products list which I wanted to create the dynamic drop down lists using formulas. I soon found out that you cannot type a FILTER formula directly into the Excel Data Validation source box. After a bit of researching, I figured how to to create dynamic dropdowns by referencing a spill range. The way I've set it up is probably a bit messy (but it works). At the moment the user has to select the category of product they want first. Then the drop down list in Product Description will show only items in that category. When they select the item they want, the drop down list for Code will show the specific code that item relates to. It can work but I was hoping to be able to use partial searches in any of the 3 columns to generate suggestions. eg. Start typing partial item name which would then narrow down options in the drop down list for Products as you type each letter. Select the item and the category and Item Code self populates. Also enable the user to partially type item code or category for a similar result. Hope this makes sense. And if so, any ideas? submitted by /u/AdComplete9707 [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]
- Change Sheet reference based on cell valueHopefully the title makes sense. Below is a snippet of what I'm working on. What I'm wanting to do is have the data table being referenced in the VLOOKUP change depending on the cell value above it. Right no I've just been manually changing each one to match. This is fine busy work but I get antsy after Data20. https://preview.redd.it/uov729eulztg1.png?width=803&format=png&auto=webp&s=6a2027958c3e56fd7f9800fcb8fa603092effb61 I'm also open to other ideas if you have them. Thanks! submitted by /u/BagConfident2457 [link] [comments]