Help with Data Validation

I have a spreadsheet and has been working fine up until a week ago.
Some cells have data validation conditions in them to restrict the valve depending on a maximum length entered
For some reason this is now not working and I can enter a number in the cell that I know is under the restrictions and I still get error message

any thoughts

File is attached

Any help appreciated

Hi,

I had a quick look by coping the data validation formula in to the cell directly to see what the max value would be and I saw that the Z335 was reporting the max value for the last entry on the lookup table, so it seems it wasn't able to locate the lookup value.

I added ",FALSE" to the end of the validation so that it located an exact match, which seemed to work in my quick tests.

=VLOOKUP(A31,Aluminium!$A:$D,4,FALSE)

I didn't look in to why it was not working without it.

Hope it helps

Jon

Cheers Jon,, works perfectly

I didn't look in to why it was not working without it.

Click to expand...

Without FALSE or 0 at the end, VLOOKUP assumes (defaults to) TRUE or 1, which is NOT an exact match (it's an approximate match). It's always best to add the lookup type argument.