I have a column which I have validated using the Data, Validation method.
I have used :
=ISNA(VLOOKUP(C7,C$6,1,FALSE))
and dragged it down the entire column.
I need this code to be disregarded if the user enters a '-' at the end of the value in the cell...i.e. if the user enters 150 the code will still work and if there is a duplicate then the error message will appear. But if the user enters 150- then even if there is a duplicate the message will not apear.
I am completley stuck on this one... please help
Bookmarks