Select from a term list, but input the corresponding key

[Travis Kunnen]

Hello All

So im working on a data sheet for customers, and we want to replace long sample names with a key as a drop down list.
So Cells A86 to A90 are the keys (A, B, C, D, E etc). and the matching / corresponding samples names are in B86 to B90 (lower level plain, upper level plain, upper embarkment, lower embarkment, flood plain flats).
The key will always be A, B, C, D, or 1, 2, 3, 4 etc, but the sample names will always change depending on the source of the sample.

In our work list, starting on E15, I would like a formula / drop down list... where the user can click a list and see the full sample names in B86 to B90.. but once selected, the key is input, and then again for E16, E17, E18... to select many samples for the same test...
And then E16 (which is a different test), and then again a drop down list to select the full samples names in B86 to B90, once selected, show the key only.
This is going to continue from E15 to E81.
We can add in as many columns as we like to accommodate the tests, if multiple samples cannot be selected and included within the same cell.

There are additional keys in D86 to D90, G86 to G90 and J86 to J90, the same as additional sample names, one column to the right of each key name.

With thanks
Travis...