Pls see attached spreadsheet.
In cell b15 I'd like to have the ability to pick from a drop-down list given by the 'green' shaded area.
In cell b16 I'd like to pick from a drop-down list; the available contract types conditional on the counterparty chosen in cell b15. And this reads from the relationship given in the 'blue' shaded area.
Thanks for your time and effort!