My formula is =INDEX(C9:C12,MATCH(B16,B9:B12,0))
where:
C9:C12 are numbers that are paired with a non-alphabetical list of words in B9:B12.
B16 is the first cell in a column in which the words in the B9:B12 list appear as the result of a formula which picks them up from another sheeet.
If I...