Thread: formula converting number to column letter 26
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid
 
Posts: n/a
Default formula converting number to column letter 26
Keith

From your formula I understand that InfoLists!D19 currently contains
the numbers 0-25, to reference columns 1-26. With this philosophy, the
following formula should work:

=INDIRECT(("RawOut!" & IF(InfoLists!D19<26,CHAR(InfoLists!D19+1+64) &
"1",
CHAR(INT(InfoLists!D19/26)+64)&CHAR(MOD(InfoLists!D19,26)+1+64)&"781"))

HTH
Kostis Vezerides

Reply With QuoteReply With Quote