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.