Hi guys,
I deal with a lot of weird identifiers that I can never remember and I was wondering if it would be possible to create a dropdown list that returns an element from an adjacent list. So if you refer to the list below as an example, let's say my drop-down list would be counterparty (names that I recognize) but when I actually click on one of those list elements, the adjacent element from the "CUID" or "BIC" column would populate (numbers I can never remember by heart) in its place. How would I go about doing that?
<colgroup><col><col><col></colgroup><tbody>
</tbody>Thanks!!
I deal with a lot of weird identifiers that I can never remember and I was wondering if it would be possible to create a dropdown list that returns an element from an adjacent list. So if you refer to the list below as an example, let's say my drop-down list would be counterparty (names that I recognize) but when I actually click on one of those list elements, the adjacent element from the "CUID" or "BIC" column would populate (numbers I can never remember by heart) in its place. How would I go about doing that?
COUNTERPARTY | CUID | BIC |
NESS | N987T754I | N235E983SS |
CASGRAIN | CAS9123365 | |
CIBC | C6I851B9C7 | |
DESJ | V213M78DM | V1A4M4D6CAM1 |
LAUR | L75A66U9R1 | BL8C4MCA8M |
NBF | N9B323612S | |
RBC | DOM7854A | RB1D7S6CAT1 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>