View Single Post
  #1   Report Post  
Sarah_Lecturer
 
Posts: n/a
Default Enter one value, Return another

Help!

I want to be able to enter a letter in say cell C2 and having pressed enter
return a figure...

A = 12
B = 10
C = 8
D = 6
E = 4
F = 2
U = 0

Any suggestions PLEASE?

Thanks

Sarah

Have it working on a Vlookup table but obviously cannot do this without
having two rows one for the answer and one for the formula - otherwise
circular reference returned!!

Thanks