Hi,
Trying to figure out how to either allow a user input or pull a value from a particular cell in a PC look-up table.
I have a check box, which will either allow users to make a choice, or to use predefined values from a look-up table, based on an entered value (it’s actually a value created by 2 user entered values, but a variable non-the-less)
I’m assuming a Dynamic list is what I want here, and have it working so that I can make it active when the check box is checked. This is list 1.
But I can’t figure out how to make it look at a particular cell when a particular value is entered by the user (the combined value mentioned above). Ideally, I want it to look at a particular row based on the above user value, and a column based on the item this is referring to. The dynamic list doesn’t seem to support ‘pick a row and column based on 2 variables’