Excel vlookup Assistance

[CyberTrek]

Hello. I am having a bit of an issue trying to make a VLOOKUP formula.

I have in column A these entries:

sysD123
sysG123
sysH123

I am trying to make a formula in column B that will see the 4th character (in this example, I capitalized them) and name them based on the criteria that D=delta, G=gamma, H=hoyboy.

So, B would have these:

Delta
Gamma
Hoyboy

But, I can not get it to see the character correctly, only the cell.

Any help be appreciated.

Thank you.

[CyberTrek]

Got it figured out.

So, you got system names in A.

sysD123
sysG123
sysH123

In another tab, called Lookup in this case:

-D delta
-H gamma
-G hoyboy

Formula in main tab column B:

=VLOOKUP(MID($A2,3,2),Lookup!$A:$B,2,0)

MID($A2,3,2)
Taking the value in A2, starting with the third character, take the two characters after.
WX-D1000
3rd character is starting point, the dash.
Two characters are -D.

In the tab Lookup, using !, look in A and B, matching the two characters from MID, and matching with the results in B.