I have a drop-down list in both cells A1 and A2 each with different values. I am trying to let a vlookup override the drop-down list in A2. For example when you select 'Leave' in A1, A2 must automatically choose a specific value from the drop-down list in A2 that cannot be changed.
I tried a vlookup as follows: Say A1 source data is AA1:AA5 and A2 source data is BB1:BB5. I created another column AB1:AB5, which is equal to the corresponding source data in BB1:BB5 (AB1=BB1, etc.). So the vlookup in A2 would go: =vlookup(A1,$AA1:$AB5,28,FALSE). However, an error message pops up saying "This value doesn't match the data validation restrictions defined for this cell." I thought that since the vlookup fills A2 with a value taken directly from the source data BB1:BB5 (as it is equals to), it would see it as a valid value but it does not.
Hope my explanation is clear. Any ideas?
I tried a vlookup as follows: Say A1 source data is AA1:AA5 and A2 source data is BB1:BB5. I created another column AB1:AB5, which is equal to the corresponding source data in BB1:BB5 (AB1=BB1, etc.). So the vlookup in A2 would go: =vlookup(A1,$AA1:$AB5,28,FALSE). However, an error message pops up saying "This value doesn't match the data validation restrictions defined for this cell." I thought that since the vlookup fills A2 with a value taken directly from the source data BB1:BB5 (as it is equals to), it would see it as a valid value but it does not.
Hope my explanation is clear. Any ideas?