Hello all,
I am working on a file which has 2 columns where data validation is needed. Let us assume the source FOR VALIDATION is the data given below:
This needs to be validated into two columns, let's say A1 and B1, where a user selects a in cell A1 form a drop-down (Maths, English....) he will get the relevant list in a drop-down in cell B1 (he will get B,C,D if he selects English). Now, you might be thinking this is a very simple IF condition, but this is just a sample of the original data, which is huge and has many more such lists. So, the nested IF condition I put there was greater the characters allowed in the customer validation field. So, I used LIST NAMES and named all the lists, then used =INDIRECT(A1) in the validation for cell B1. (Hope this is making sense)
Now the problem is, I get all the values of the subjects in A1, but for some reason when I select the first or last value form A1 (Maths and PE in this example), it simply DOES NOT show up any of the values in the list. All other values in between (English, Physics, Chemistry) are working fine. Hopefully I find a solution here as I am having a headache from this. Thank you.
I am working on a file which has 2 columns where data validation is needed. Let us assume the source FOR VALIDATION is the data given below:
Maths |
|
| Chemistry | PE | ||
A | B | A | A | A | ||
B | C | B | B | C | ||
C | D | C | C | F | ||
D | E | D | G | |||
E | E | |||||
F | ||||||
G |
This needs to be validated into two columns, let's say A1 and B1, where a user selects a in cell A1 form a drop-down (Maths, English....) he will get the relevant list in a drop-down in cell B1 (he will get B,C,D if he selects English). Now, you might be thinking this is a very simple IF condition, but this is just a sample of the original data, which is huge and has many more such lists. So, the nested IF condition I put there was greater the characters allowed in the customer validation field. So, I used LIST NAMES and named all the lists, then used =INDIRECT(A1) in the validation for cell B1. (Hope this is making sense)
Now the problem is, I get all the values of the subjects in A1, but for some reason when I select the first or last value form A1 (Maths and PE in this example), it simply DOES NOT show up any of the values in the list. All other values in between (English, Physics, Chemistry) are working fine. Hopefully I find a solution here as I am having a headache from this. Thank you.