Using XLOOKUP

Your forum profile says 2007, but XLOOKUP is available only in 2021 and newer - please update your profile NOW.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Do you have another account here? An almost identical question was asked here recently ...

Is this you?

https://www.excelforum.com/excel-gen...o-figures.html

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.

OK - well that's somewhat confusing, especially as the other account says that you have Office 365. You really should have declared this at the very start of this thread!

What is the issue you are having logging in? If you give me details, I can get the tech team to look into it for you. Send me a PM.

I am closing this thread as a duplicate. You can respond with your new account in the original thread - there is already a suggestion there to which you have made no response.

Continue here: https://www.excelforum.com/excel-gen...o-figures.html