In the absence of a workbook, you could try this:

=LOOKUP(A1,{"A","F","K","U","WE"},{1,2,3,4,5})

Change the values in red to the values you wish to return for each letter.