Equation for Letters equating to figures

[j0SAND]

In row 1, column "A" (question) " how much is that " ,column "B" (Answer) for instance letter "G" and in column "C", letter " G" equates to let's say 37.50.

Column. ..... A........B.......C
Row1. ..... Question...G......37.50

Note to all participants:

j0SAND and Bailymaus are the same person.

[AliGW]

What's the question?

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.

[AliGW]

Fir the avoidance of doubt, I am waiting for you to attach a sample workbook.

[ByteMarks]

Maybe

Please Login or Register  to view this content.

[j0SAND]

Looking for an equation to convert a given letter to a figure, as an answer to a question. The question can be answered by many letters where each letter equating to a different figure,ie answer A means 20, B means 50, C means 37.50 and so on.
Column A, question. Column B, answer. Column C, the figure.

[AliGW]

Waiting for a workbook, but it sounds like you need to set up a lookup table and then use XLOOKUP.

[Bailymaus]

I have an idea which involves a question in column A. The answer which is to be given in column B is a single letter or pair of letters, from a group of 5. lets call them A, F, K, WE and U.
These letters equate to a value to be used elsewhere in the spreadsheet.

At the moment i do not have a spreadsheet, just and idea and it has been suggested that using " XLOOKUP " is a possibility to get to where i want.

as an example,


A B
________________________
paid? A

Paid? U

non paid? F

non paid? WE

Paid? K


Each answer in column B has a different value.

I hope this enough to help you advise me if " XLOOKUP " is the way to go and offer a suggestion.

[AliGW]

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.

[AliGW]

Note to all participants:

j0SAND and Bailymaus are the same person.

[AliGW]

So, do you have Excel 2007 or 365?

Please respond to the suggestions offered for 365 in post #4 and for 2007 in post #8.

If neither helps, then you MUST provide a sample workbook, manually mocked up.

[Bailymaus]

At the moment excel 2007

[Bailymaus]

I would like to thank you for the help and expertise in handling my question. It has been long and drawn out due to my inexperience but time has prevailed. Your suggestion of
" =LOOKUP(A1,{"A","F","K","U","WE"},{1,2,3,4,5}) " worked after changing the comma`s to semi colons (a previous problem that I had experienced once before and just managed to remember).
I am in the process of upgrading my 2007 version to a newer one and hopefully make thing easier.

[AliGW]

We need to get to the bottom of your profile issue so that you can use the other (original) account and this one can be closed. The old account tells us that you are already using 365!

Please send me a private message with details of your logging in issues so that I can contact the tech team.

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.