ExcelBanter - Generating a drop-down list from an IF function

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Generating a drop-down list from an IF function (https://www.excelbanter.com/new-users-excel/122263-generating-drop-down-list-if-function.html)

KP@RG

Generating a drop-down list from an IF function

How do I get a drop-down list to be the if_true result of an IF function? I
have a drop-down list. I want another drop-down list to be generated as the
result of the selection of the first drop-down list. Anybody know if it's
possible?

Ron Coderre

Generating a drop-down list from an IF function

For instructions, see the Dependent List section of Debra Dalgleish's website:

http://www.contextures.com/xlDataVal02.html

Does that help?
***********
Regards,
Ron

XL2002, WinXP

"KP@RG" wrote:

How do I get a drop-down list to be the if_true result of an IF function? I
have a drop-down list. I want another drop-down list to be generated as the
result of the selection of the first drop-down list. Anybody know if it's
possible?

KP@RG

Generating a drop-down list from an IF function

That's exactly what I needed. Thank you very much.

"Ron Coderre" wrote:

For instructions, see the Dependent List section of Debra Dalgleish's website:

http://www.contextures.com/xlDataVal02.html

Does that help?
***********
Regards,
Ron

XL2002, WinXP

"KP@RG" wrote:

How do I get a drop-down list to be the if_true result of an IF function? I
have a drop-down list. I want another drop-down list to be generated as the
result of the selection of the first drop-down list. Anybody know if it's
possible?

All times are GMT +1. The time now is 07:59 AM.