Function returns a list

[Rana]

I’m searching for a function to do the following:
If I’m talking about the cell D2 for example
check the value in C2, if it is a certain value for example (2) than D2
returns a value, for example (89), if and if it’s (7) I need D2 to give me a
list so I can choose the value that I want.

 

[Barb Reinhardt]

It sounds like you are looking for some dependent lists. Take a look at the
link below and see if it gets you what you want.

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

HTH,
Barb Reinhardt

 

[Rana]

Thanks Barb, that's what I've been looking for.

It sounds like you are looking for some dependent lists. Take a look at the
link below and see if it gets you what you want.

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

HTH,
Barb Reinhardt