Thread: How do I assign a value to an Alpha character in order to do calc
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default How do I assign a value to an Alpha character in order to do calc
Assume A to Z in D1:D26 and 1 to 26 in E1:E26

In B1 enter =LOOKUP($A1,$D$1:$D$26,$E$1:$E$26)

Enter a letter in A1 to return a number in B1 which you can calculate with.


Gord Dibben MS Excel MVP

On Sat, 4 Oct 2008 08:27:00 -0700, Gail
wrote:


Reply With QuoteReply With Quote