A few Excel tips
Search on the second column of a range and return the value in the first column (or any column). The native VLookup formula is designed to only search on the first column.
Check the validity of a code: only permutations of a given range of letters are allowed. The example use A, B, C and D but you can of course choice your own.
From a string, remove everything that isn't a digit.
