Excel Tables as source for data validation lists

Excel Tables as source for data validation lists

2 May 2013

I've set up a table with some team names that I want to use in a Data Validation list. The reason I formatted my list in an Excel table is because I want the range to dynamically update when I add or remove teams from the list.

Now, if you've ever tried to reference an Excel Table as your Data Validation lists... then you probably got the error: "The formula you typed contains and error". Here are two ways to fix this...