Hi, i have two dropdown list in A1 and B1.

A B
john b32
mary b66
jim b55
cris b88

i need to link somehow this two dropdown list, so when i select in A1 mary,
in b1 to appear b32. Or when i select in B1 b88, in A1 to appear cris. but i
need both to be dropdown list.

Can this be done?
Thanks.