Conditional Drop Down without a Macro

vilas desai
3StarLounger
Posts: 307
Joined: 16 Mar 2011, 09:33

Conditional Drop Down without a Macro

Post by vilas desai »

Hello All Experts

A very very happy new year 2022
I need a help.
I am looking for something like this:
If Cell A1 = Inch, then B1 = 10 or 11 or 12
else if A1 = DN, then B1 = 13 or 14 or 15

No macros please
Thanks and best regards
Vilas Desai

User avatar
HansV
Administrator
Posts: 78235
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Conditional Drop Down without a Macro

Post by HansV »

See the attached sample workbook. It uses named ranges and the INDIRECT function.
See the Name Manager on the Formulas tab of the ribbon for the definition of the named ranges.
Select B2 and click Data Validation on the Data tab of the ribbon for the ue of INDIRECT.

Sample.xlsx
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

vilas desai
3StarLounger
Posts: 307
Joined: 16 Mar 2011, 09:33

Re: Conditional Drop Down without a Macro

Post by vilas desai »

Thanks Hans, I was hoping to have a formula without additional sheets or ranges. But This will also work as I will hide the extra ws with a password.
Best regards
Vilas

User avatar
HansV
Administrator
Posts: 78235
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Conditional Drop Down without a Macro

Post by HansV »

If you don't want to use VBA, the source needs to be a range...
Best wishes,
Hans

vilas desai
3StarLounger
Posts: 307
Joined: 16 Mar 2011, 09:33

Re: Conditional Drop Down without a Macro

Post by vilas desai »

got it. Thanks again