Help needed:Changing dropdown values based on look up cell

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

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?

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)

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.