DV Lists that update each other
I have two DV lists. What I would like is for the second list to
update its value based on the selection in the first list, and vice
versa.
The reason for this is I'd like to be able to select something based on
its name, or based on its corresponding number. If I select based on
name, I'd like the number in the adjacent cell to update. If I select
based on number, I'd like the name in the adjacent cell to update.
Does anyone know if this is possible, and how to implement this?
Thanks in advance!
|