R
Rui Freitas
I have 2 sheets, Sheet1 with several lists and sheet2 with the lists contents
(named ranges, etc). On sheet1, cell C2 I have a list to choose from several
entries including one named "International" and another "Other Stuff". On
cell C3 I have a dependent list from my choice in C2 in which I use on the
Source of the Data Validation the following
=INDIRECT(VLOOKUP(C2;NameLookup;2;1)) . And when I choose either
"International" or "Other Stuff" on C2, I get in C3 the sub-lists I want,
without problem.
The question is when I choose anything other than those two I don't get
access to a list in C3, because the others don't have sub-lists, and I want
C3 to automatically fill the cell with "Not Available". Almost like using a
IF function and TRUE access a the sub-list and FALSE fills with the text "Not
Available".
Can anyone help with this?
Thanks
(named ranges, etc). On sheet1, cell C2 I have a list to choose from several
entries including one named "International" and another "Other Stuff". On
cell C3 I have a dependent list from my choice in C2 in which I use on the
Source of the Data Validation the following
=INDIRECT(VLOOKUP(C2;NameLookup;2;1)) . And when I choose either
"International" or "Other Stuff" on C2, I get in C3 the sub-lists I want,
without problem.
The question is when I choose anything other than those two I don't get
access to a list in C3, because the others don't have sub-lists, and I want
C3 to automatically fill the cell with "Not Available". Almost like using a
IF function and TRUE access a the sub-list and FALSE fills with the text "Not
Available".
Can anyone help with this?
Thanks