Thread: Help with Address(), Indirect(), Offset
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
James Ravenswood James Ravenswood is offline
external usenet poster
  
Posts: 143
Default Help with Address(), Indirect(), Offset
We need to "make" the string "C10" and input that string to INDIRECT(). One way:

=INDIRECT(CHAR(CODE(MID(A1,2,FIND("$",A1,2)-2))+1) & MID(A1,FIND("$",A1,2)+1,256))
Reply With QuoteReply With Quote