J
jmc784
Can someone please tell me if this is possible?
What I want to do is have a drop-down list, but when you choose a value from
the list, it inputs the value from another list.
for example, if I have the two lists from columns B and C, can I have the
drop-down list have the values in column B, but when you choose the value, it
inputs the value from column C?
If I choose 3 from the drop-down list, I want it to show C in the cell.
A B C
1 1 A
2 2 B
3 3 C
Thanks!
What I want to do is have a drop-down list, but when you choose a value from
the list, it inputs the value from another list.
for example, if I have the two lists from columns B and C, can I have the
drop-down list have the values in column B, but when you choose the value, it
inputs the value from column C?
If I choose 3 from the drop-down list, I want it to show C in the cell.
A B C
1 1 A
2 2 B
3 3 C
Thanks!