I need to make a drop list. There will be 2 col. One named ranged "ID" one Col Range named "Prod"
I want a prod list generated dependent on the ID thats selected from the drop down list.
It needs to be dynamic. Every row one can have a diff ID.
I hope Im making sense. I did try to use a simlar tutorial using the INDIRECT function on the Validation tool. But it doesnt do what I need.
I want a prod list generated dependent on the ID thats selected from the drop down list.
It needs to be dynamic. Every row one can have a diff ID.
I hope Im making sense. I did try to use a simlar tutorial using the INDIRECT function on the Validation tool. But it doesnt do what I need.
