Data Validation to force Uppercase and From List only Text

[IFSSCref]

Hello all,

I am looking for a formula that will restrict any values in a cell to UPPERCASE as well as a predefined list of cells only. This list is limited to "FS, TS, DS, LA" for the entries. Part of the formula I have works, but I cannot seem to get it to function 100%.

Please Login or Register  to view this content.

So when I test this it lets me enter in the FS and TS (the first 2 on the list - AY14 and AY15) perfectly and in uppercase only. When entering the last 2 on the list (DS and LA - AY16 and AY17) I get an error "This value doesn't match the data validation restrictions defined in this cell". Can someone help tell me where the error lies in my code? Thanks in advance.

[Root_]

Try

=EXACT(B13,VLOOKUP(B13,AY14:AY17,1,0))

[IFSSCref]

That did it. Thank you!!