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