I have three 3 lists that a user selects from:
- Rating - AAA,AA,A,BBB
- Term, 1-3, 3-5, 5-7, 7-10, 10-15, 15+
- Sector - Fin,Non-Fin, Sec/Col, Sovereign
I'd then like to pick out the relevant cell from the screenshot after the user has selected a value from each list.
I have the drop-downs in D4:D6 on another sheet, and I'd like to select data from the tables in this screenshot: