Using INDEX MATCH with results of a formula

[John McPhee]

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 type the words into B16 and the cells below, the formula works.
If I type the words into the formula instead of B16, the formula works.
But when the formula is looking for the word in col B that appears as the result of the formula, I get #N/A.

Any clues?

 

[John McPhee]

Thank you!!!!!! You have saved my sanity. I really thought I was losing it.

 

[mrshl9898]

Glad we got there