Excel 2007

Working with 2 workbooks. In RESULTS.xlsx I have a Data Validation set
up on a Column using a named range (Data) on a separate worksheet. The
data validation works fine if I am manually entering information. The
problem/question comes when I try to use a vlookup formula to pull
data from SOURCE.xlsx, the data validation does not seem to 'catch'
the 'bad' data.

I'm thinking I may have to write the validation into the formula or
try something with conditional formatting. Either way, I'm at a loss.

Any assistance would be appreciated.

Thanks!
Tanya