I'm not sure that I understand your question, but if I read it
correctly, you want to do a lookup on the 5th character in a alpha/text
number from a data list that is in E84:E86, (assuming that there are
data labels in D84:D86.

If this is the case, try using the following formula in B1:

VLOOKUP(MID(A1,5,1),D84:E86,2)

Hope this helps.

JimB