Auto fill in cells

[Man Utd]

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?

[mangesh_yadav]

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

Mangesh