Formulas

  • Thread starter Thread starter Raja
  • Start date Start date
R

Raja

I wanted to enter a number in a cell for example 10 in A2 and this number
should be converted into a letter say "A"in A2 cell. How could it be done?
 
Setup a table somewhere definining what values correspond to what output,
and then use a VLOOKUP/LOOKUP function.

=VLOOKUP(A2,My_Table,2,FALSE)
 
Could you please elaborate your requirement..What if you type something else
other than 10.

If you just want any number typed into cell A2 to be displayed as A; then
custom format the cell as below

"A"
 
Back
Top