I'm fairly new to excel. I have googled this with no help. I will try to explain this the best way I can.
I have a field that I created a dropdown from a named range. I then want to use the value selected to create another dropdown list, but its filtered to only display certain values from the table. I will then use that to do vlookups and populate the rest of my layout. I have tried INDIRECT and VLOOKUP formulas and cannot find the right combination.
So as this table grows with different configurations, I want to be able to select from the list in A4 (which is pulled from H11-H13) and then it filters and only shows values from B11-B40 that match in column A of that table. I think this is possible to do, but I've been struggling with it for the past few days and I am not getting anywhere. I am hoping my question makes sense. Please let me know if you need more info.
I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)
I have tried both suggustions above and I haven't really been able to make either work. I changed my table slightly to work better with another issue I was having, so I have adjusted the formulas. I cannot get the "POSITION" column to work. I am not sure what the issue is. It must be something simple.
I was able to get farther with @alz suggestion. I do have a couple of questions about it.
It doesn't seem like it works in tables. So will I need to expand the formula to cover more cells as I get more config options in the future?
I need to be able to have 4 rows to choose options in. The playbook will always stay the same. The only variable is CONFIG and POSITION. The position field should be a number between 1-4.
I've updated my sheet and this is what I am currently working with. I plan to add more fields as I build out the CONF table.
Let me know if this makes sense. Thanks again for the great responses! As I am new, I am still googling and trying to learn as much as possible.
Answer(2)
(From unique table ) position Columns calculate depend on A2 and Node config column is calculate depend on C2. we can trick the formula by using volitile function Cell("Address") and refer with indirect formula So whenever you click or enter Cell("Address") will show the address of that cells So that the position Columns and Node config column will calculate depend on that active cell
( For example . you click on C10 formula will calculate depend on C10. Writing something on D10 formula will calculate depend on D10)
you need to careful one thing , ---- after you click on A3 you need to select on B3
---- if you want to input Data on B4 click A4 first and then input B4
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
