Need formula for text to convert to value.

[SnowBrian]

Good Morning Forum. Sorry this is probably something basic and I use to be so good with these formulas but my brain is fried right now and I cant remember how to do this. And its been a long time since Ive had to put a formula together.

Whats the formula/function if I want to have a letter convert to a number. One cell will still need to see the letter but then a side cell off to the side can then convert that letter to a number? For example:

R=1
I=1
S=1.25
P=2
F=2
J=2

Thank you for your time.

[JohnTopley]

VLOOKUP with table of letters and corresponding numbers?

[SnowBrian]

Damn VLookup. I just couldnt remember that function. Thanks for the reply. Yes, thats what I was looking for. Thanks!