Only wanting certain text to be allowed as input

[Pauljj]

I have a column which I want a 4 letter code to be input, however there are 80 different versions of code, ie AYHU or SHTG etc etc but I only want these specific codes to be inout, if someone tries to enter a code which is not in a pre-determined list I dont want the user to be able to carry on. Now i guess this can be done with data validation and VLOOKUP but I cant remember how....any help please!!


Paul

 

[Barry Katcher]

Hi, Paul.

Not with VLOOKUP.

Use Data>Validation>Settings, Allow:List and point to the source of your list of allowable entries.

Barry

 

[Pauljj]

I had tried that but my 'list' is on page 3 and it comes up with a message saying You may not use references to other worksheets for data validation criteria ??? which I dont understand, as i am sure I have done this before???

 

[2rrs]

I had tried that but my 'list' is on page 3 and it comes up with a message saying You may not use references to other worksheets for data validation criteria ??? which I dont understand, as i am sure I have done this before???

Try giving your list a "named range"

 

[Barry Katcher]

Yes, as 2rrs says, give the list on sheet 3 a name, such as MyValidationList, and then, in Data>Validation>Settings, in the Source bar, enter =MyValidationList.