Before I explain why your formula has double square brackets, it's important to understand the difference between direct and ...

If you've used data validation in Excel before, you probably selected the relevant cells, clicked "Data Validation" in the ...