Not easy but it is possible by exploiting the technique described here. It
allows you to have text appear in a cell based on a formula that is in a
different cell via the camera tool.

http://spreadsheetpage.com/index.php...e_camera_tool/
--
HTH...

Jim Thomlinson


"puiuluipui" wrote:

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.