excel formula working on a cell which is having data in a data validation cell

excel formula(Vlookup) working on a cell which is having data in a cell which already having data validation,
But its not working when i enter a formula in a blank cell which is already having data validation.. Any help on this

Thanks

Any chance of uploading the spreadsheet or at least a sample to help clarify things?