K
Kathrine
Just upgraded to Excel 2007.
In Data - Validation - List (dropdown) i want to refer to the values/data in
a specific column in a defined table, like
=Person[Name]
using relative cell references like the one above. Person is the name of the
table, Name is the column header containing the names that should be
validated against.
This works fine with ordinary formulaes, but not in data validation dialog
box = "Error in formula" - message.
Any ideas?
In Data - Validation - List (dropdown) i want to refer to the values/data in
a specific column in a defined table, like
=Person[Name]
using relative cell references like the one above. Person is the name of the
table, Name is the column header containing the names that should be
validated against.
This works fine with ordinary formulaes, but not in data validation dialog
box = "Error in formula" - message.
Any ideas?