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.
Bookmarks