Simple question that I'm frustratingly close to figuring out.
On Sheet A, I have a column for a list of {Operators} with a {Discipline} column next to it, indicating whether or not said Operator is cleared on said Discipline. We're using the "Yes," "Hold," and "No" symbols.
On Sheet B, I have, essentially, the exact same thing. The only difference is that for Sheet B's Operator column we'll be using a dropdown list. So, the goal is that when someone updates the dropdown column with a specific Operator, it'll spit out that Operator's cleared Discipline.
This can either "copy" the cell from Sheet A, because it'll be the exact symbol, or update the cell in Sheet B. I know it's simple, I'm just not formula-savvy.
