B2 has Dropdown list referring to a namerange A1:A9 (text entries)
How to fill B1 & B3 based on B2 selection sequentially
Ref. attachment.
B2 has Dropdown list referring to a namerange A1:A9 (text entries)
How to fill B1 & B3 based on B2 selection sequentially
Ref. attachment.
Last edited by jilaba; 03-11-2009 at 10:30 AM.
Ask me how to hate XL.
use index and match..
check the attachment
Shijesh Kumar
http://shijesh.wordpress.com/
Wasn't you look for same problem few days ago?
It was solved... It wasn't good or?
http://www.excelforum.com/excel-new-...ous-cells.html
Last edited by zbor; 03-11-2009 at 09:16 AM.
Attachment 38625
OK, here's moderated above file (because it doesn't work with first and last cell)...
Is it problem to add vritually Brick and Electricity (look A1 and A10, are not empty only white)...
This way formula works without VBA
Last edited by zbor; 03-27-2009 at 04:50 AM.
use this in B!
Please Login or Register to view this content.
and this is b2
Please Login or Register to view this content.
Yes, this is nicely
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks