Could it be something in my Excel settings?
I'm not sure. The INDIRECT wrap in the DV should work. But it is presumed
that the text result returned by the vlookup is a defined name referring to
either a single col range or a single row range. Maybe you could try
re-defining your precedent source ranges to ensure that this happens.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Leslie" wrote:
I changed my source to what you suggested, but now I get another message.
"The Source currently evaluates to an error. Do you want to continue?"
The names work great if I don't use the validation.