It's kind of involved. See this:

http://contextures.com/xlDataVal03.html

--
Biff
Microsoft Excel MVP


" VLOOKUP fORMULA" wrote in
message ...
Any one pls help me....?

I am having a data validation rule in sheet1, data taking from sheet2
using
a drop down menu.

My problem is that I am entering the same items twice.
Is there any way to avoid duplicate.