Ok so basically I have a 4-5 categories to choose from in my sheet, and each drop-down is contingent upon the next one.
I'm using =INDIRECT(D12&E12) and =INDIRECT(D12&E12&F12) and=INDIRECT(D12&E12&F12&G12) and so on and so forth or some formula similar to that. The problem is basically that when I fill in D12 and E12 I get another dropdown in F12 that is correct, but i also get the exact same dropdown in G12, which is completely incorrect and should not be possible.
How can I fix this?! it's driving me mad!
I'm using =INDIRECT(D12&E12) and =INDIRECT(D12&E12&F12) and=INDIRECT(D12&E12&F12&G12) and so on and so forth or some formula similar to that. The problem is basically that when I fill in D12 and E12 I get another dropdown in F12 that is correct, but i also get the exact same dropdown in G12, which is completely incorrect and should not be possible.
How can I fix this?! it's driving me mad!
