Try this:

=lookup(B2,{v,w,x,y,z},{5,10,15,20,25})

A note on this: Anything inside the first {} must be in ascending
alphanumeric order.

"AbbysMum04" wrote:

I am not an excel expert so I'm hoping someone reading this might be. I am
attempting to create a "Scoring" sheet with pre-set values for criteria.
What I would like to do is program this type function into each individual
cell:

eg. If the value of B2 is "15" then 'x' equals 15.

I would like the user to simply enter the letter 'x' in the cell, not numbers.

Does this make sense? Any feedback would be greatly appreciated. Thanks