excel formula(Vlookup) working on a cell which is having data in a cell which already

sujithy007

New member
Joined
Apr 2, 2013
Messages
15
Reaction score
0
Points
0
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
 

DILIPandey

New member
Joined
Oct 20, 2013
Messages
9
Reaction score
0
Points
0
Location
Dubai
Website
mvp.microsoft.com
Hi Sujithy007,

I guess - both cell has data validation rules already set up. One cell is having a data chosen from data validation and vlookup is working here but not working on the other cell which is having blank.. correct ?
Can you upload a sample workbook ? Thanks.



Regards,
DILIPandey
 
Top