Hi All,
I have a scenario when i pasting the values in A2 column the B2 column drop down have to change by looking at the values pasted in A2 cell.
I have attached an example file for reference.
Thanks
Elango
Hi All,
I have a scenario when i pasting the values in A2 column the B2 column drop down have to change by looking at the values pasted in A2 cell.
I have attached an example file for reference.
Thanks
Elango
Last edited by Elangovan89; 01-06-2014 at 12:30 PM. Reason: My problem has been resolved.
Looks like you don't want a dropdown as there is only 1 correct entry for any value in A2. You want a formula
In B2 copied down
=IF(OR(A2={"banana","Apple","Orange"}),"Fruit", IF(OR(A2={"Carrot","Potato","Tomoto"}),"Vegetable", IF(A2="Beer", "Drink","")))
Questions?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Hi Chemist,
Yeah, I have a question in case if more than a 1 correct entry how it could be done?
Thanks for your help!
Hi Chemist,
How you put {} for criteria's in formula.. If I type Manually it doesn't take Criteria. If I Use CTRL+SHIFT+Enter, it takes full formula into array.
Thank you for your help.
Elangovan
Read up on it here: http://www.contextures.com/xlDataVal02.html
Chetansuri,
In this case, they are manually entered. These are not entered with CNTRL SHFT ENTER. I tested them before I replied. If you have a specific issue, start a new thread and upload a workbook (Go Advanced>Manage Attachments)
Chemist,
I have already goggled that page. Here in the A2 cell I am not using drop down I am copy pasting the values. Hence based on the pasted values the drop down values have to change.
It would work the same way, just skip the part where you set up the initial dropdown. In Column B would be your INDIRECT dropdowns.
If it's still not making sense, maybe upload a better example where column B can have more than one result.
Here is a complex example using your original example, where you have many possibilities which narrow to a few catagories (fruit, vegetable, drink) which expand to a list. Here we'd use a combination of VLOOKUP and INDIRECT. See attachment.
Hi Chemist,
It was awesome!!! I really appreciate your help on this... Thank you so much. The formula was exceeded my expectations.
Keep up the good work mate!
Regards
Elango
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks