Forum Discussion
formula to auto entry an amount based on the kind
I am still struggling. I have one table that has a drop down list, when someone clicks on a name from the drop down list, I need the price per ounce to auto populate in that same table. I tried to use the following and get an error.
=VLOOKUP([@[Chemical Name]],Table1[Chemical],Table1[per Ounce])
If there is a better way to show this to you please let me know.
Thanks for any help.
That VLOOKUP is incomplete.
I think would be the correct formulation. Here's a screen grab on the correct syntax for VLOOKUP from one of my favorite on=line references ( https://exceljet.net/excel-functions/excel-vlookup-function )
You have the formula written as =VLOOKUP([@[Chemical Name]],Table1[Chemical],Table1[per Ounce])
It should be more along these lines
=VLOOKUP([@[Chemical Name]],Table1,2,0)
- In short, I think you're specifying the lookup_value correctly, but not the rest.
- table_array would be simply "Table1"
- column_index_num would be 2 for the second column of Table 1
- and 0 would be requesting an exact match
If making that change doesn't work, refer to the website I link to above. If you still can't resolve it, please post a copy of the actual spreadsheet either here or in OneDrive or Google Drive or the equivalent, and give us a link
mathetes I also am having this issue. I have a spread sheet with names, elevations and columns for each material with the quantity being used. I need to get the material quantities to auto populate when the elevation is selected from a drop down menu and can’t figure out how to get that to work.
- You'd need to provide more information, an image of the sheet at the very least, but ideally a copy of the actual spreadsheet posted to a shareable website like OneDrive or Google.
mathetes I have a link below. What I’m trying to do is get a drop down menu in columns next to each other and then the final one to populate the counts in the correct columns.
I want to have any builder we use names, when one is selected it brings up the plans for that specific builder in a drop down menu, when a plan is then selected in the drop down I’m trying to get the amount of material needed to populate in the corresponding columns next to it. Currently these all need to manually be entered and it’s time consuming.for instance the first column would select any one of our builders In the tabs below, lets say we choose MI tab, in the next column I want it generate only the the MI plan names, buckingham, flintwick etc on MI tab, once a plan is selected then next column would be elevation, using MI tab as example and say buckingham was chosen, It would then generate the next column options of elevations A,B,C. One an elevation is selected I need it to then auto populate the quantity of material needed in the columns next to it, example 30 yr bundles, 25 yr bundles, starter bundles etc…
https://docs.google.com/spreadsheets/d/17VNpTYIZcuo0rC-Ssk5we2qXsppxn-sC/edit?usp=sharing&ouid=105052994483525096198&rtpof=true&sd=true
