Hello,
I want to use a different drop-down list in a cell based on the content of another cell.
Example:
IF A1="BF1" - for current cell, use drop-down list in column G
IF A1="BF2" - for current cell, use drop-down list in column H
Is this possible? If not, is there another way to do this?
Best regards and thanks in advance.
seems like this should do the trick...
Formula:
=IF($A$1="BF1",G:G,IF($A$1="BF2",H:H,""))
although you do end up with some blanks in your dropdown, you're probably better off defining the range specifically = i.e. G2:G5, H2:H5. or if they're of a dynamic size, offset($G$2,0,0,count(G:G))
Last edited by simarui; 08-05-2014 at 05:17 PM. Reason: added the attachment and disclaimer at the bottom
You can use an IF statement and INDIRECT with named ranges.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Here is a sample workbook that might help you with your project.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Thanks very much.. you guys are great!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
seyss 
Register To Reply
Bookmarks