View Single Post
  #1   Report Post  
Sarah_Lecturer
 
Posts: n/a
Default ENTER ONE VALUE, RETURN ANOTHER

HELP!

I want to enter a letter in cell C2 and upon pressing ENTER on the keyboard
get Excel to return a value into cell C2 (depending on the letter entered in).

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

I have tried using a VLOOKUP but because I want to enter A and receive 12 in
the same cell I keep ending up with circular references - help!!!

Thanks

Sarah