Let A1:B3 contain the following table...

U    E86
V    E87
R    E84

Then, use the following formula...

=VLOOKUP(MID(C1,5,1),$A$1:$B$3,2,0)

...where C1 contains a value such as RS23U1R109000.  Adjust the table
accordingly and formula accordingly.

Hope this helps!

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

Not sure exactly where you are getting the associated number to append to the
"E", so maybe this will get you in the right direction:

This formula will return the ASCII code for the uppercase, 5th letter in
cell A1:
=CODE(UPPER(MID(A1,5,1)))

Here's what it return for various letters:
A....65
B....66
R....82
S....83
T....84
U....85
V....86

So if you meant the ASCII code, then this would work:
="E"&CODE(UPPER(MID(A1,5,1)))

BUT...
If you have some non-sequential numbers to assign to the letter, you might
try one of these:

This one assign whatever you want to the ASCII code:
="E"&CHOOSE(CODE(UPPER(MID(A1,5,1)))-64,100,105,18,23,12,109...etc to 26
value)
It subtracts 64 from the code, so A:1, B:2.....Z:26
Then, for each value from 1 to 26, you need to assign the number to return.
In my example, 1 returns 100, 2 returns 105....etc.

OR

You could construct a separate lookup table of letters with their
corresponding return value:

For lookup table in cells D1:E3
R............84
U............86
V............87
etc

and use: ="E"&VLOOKUP(MID(A1,5,1),D1:E3,2,0)

Does that give you something to work with?

***********
Regards,
Ron

I am not sure I have your pattern, but if you want the fifth character of A1
to produce the following text in B1:

A    E66
B    E67
C    E68
D    E69
E    E70
F    E71
G    E72
H    E73
I    E74
J    E75
K    E76
L    E77
M    E78
N    E79
O    E80
P    E81
Q    E82
R    E83
S    E84
T    E85
U    E86
V    E87
W    E88
X    E89
Y    E90
Z    E91
Then enter the following in B1:
="E" & CODE(MID(A1,5,1))+1

it seems that you may have helped me but I do not understand what you say, I
am sorry...
to be exact at what I am trying to do here are the exact letters and numbers
that I will be imputing and the exact letters and numbers I am needing to
show up.

RS23H1R109000  E55
RS23N1R109000  E65
RS23R1R109000  E74
RS23U1R109000  E86
RS23V1R109000  E87

So as you can see, if I type RS23H1R109000 in cell A1, I want cell B1 to
automaticly populate with E55

I need to be able to type any of the RS numbers in a cell and I need the
other cell to populate with the correct E number.

I hope that makes sense.....
Thanks again for your help, Nick