Auto fill in cells
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 |
All times are GMT +1. The time now is 08:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com