please assist me for If Statement with dropdown list.

[sampath]

Hello Dude,

I have drop down list in one cell(Example - Q24). If when i going to add if statement in B1 cell i need to show that drop down list.

For Example.

Q25 has drop down list
Q24 has "NEW"

If A1= "RT" then B1 should show NEW.
If A1= "MRCS" then B1 should show drop down list.
If A1= "RM" then B1 should show NEW

Please help for this to our dashboard creation.

Regards,
Sampath.S

 

[Somendra Misra]

Hi Sampath,

Your problem is bit confusing, Do you have dropdown both in Q25 & Q24?

Secondly, for your "MRCS" condition what dropdown should come in B1?

Regards,

 

[Luke M]

Taking a SWAG,
=IF(OR(A1={"RT","RM"}),"NEW",Q25)

 

[sampath]

Taking a SWAG,
=IF(OR(A1={"RT","RM"}),"NEW",Q25)

Hello Luke,

Thanks for your reply, but when i entering others in A1 cell, that drop down list is not shown in B1 cell.

Kindly assist me for my dashboard.

Best regards,
Sampath.S

 

[sampath]

Hi Sampath,

Your problem is bit confusing, Do you have dropdown both in Q25 & Q24?

Secondly, for your "MRCS" condition what dropdown should come in B1?

Regards,

Dear misra,

only Q25 has drop down list. And when i entering the MRCS in A1 cell, B1 cell will show that drop down list.

that drop down list contain "NEW" and "MOD".

Please assist for this to my dashboard.

Best regards,
Sampath.S

 

[Debraj]

try to search for two things... in google

* Expand dropdown list like google .. when typing.
* How to use Camera tool.. in excel

Give your best to consolidate both technique..