Thread: Help with changing column reference in formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GoBucks[_2_] GoBucks[_2_] is offline
external usenet poster
  
Posts: 57
Default Help with changing column reference in formula
I have a long complex IF formula in which the following SUMPRODUCT formula is
contained.

SUMPRODUCT(--(AE11:AE200))

Depending on the value of cell A1, I would like to dynamically change the
column reference in the formula. For example:

IF A1 = 1, THEN use the column reference AE in the formula
IF A1 = 2, THEN use the column reference AF in the formula

Is there a way to accomplish this by INDIRECT or another formula? Thanks!
Reply With QuoteReply With Quote