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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks