Auto fill in cells

  • Thread starter Thread starter Man Utd
  • Start date Start date
M

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?
 
Use a lookup formual in cells connected to the 2 dropdown boxes. Th
lookup value is the value in cell C2.

Manges
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying formulas across columns 2
countifs Function not giving desired result with date criteria 2
use cell text in lookup function 3
IF Statement 3
Variable Cell Reference 2
Looking for entries and copying to a cell 1
VLOOKUP source values are a formula result. Getting #N/A 7
Conditional sum, when condition has multiple values 3

Back
Top