I got this situation:

I have a dropdownbox in a cell A2, and another dropdownbox in B2 (depenant
list), if a user select an item in A2, B2 will populate the corresponding
dependant list, so I use formula in this dependant dropdownbox. I have 1more
cell C2. I use the formula to lookup a table to find values of the dependant
list. So far so good.

So in short, I select A2 and B2 dropdownboxes, C2 will execute its formula
to lookup a table.

Now can I do the other way round, if I enter a value in C2, I want to
populate the dropdownboxes in A2 and B2?

Use a lookup formual in cells connected to the 2 dropdown boxes. The
lookup value is the value in cell C2.

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=379562