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
|