Hi everyone,

I'm using this formula and I'm having difficulty on what's the best way to aggregate the next 12 values. Currently the formula is set up to return the first value.

=if(C3=EBITDA!B$5,hlookup($C3,EBITDA!$B$5:$CG$41,3,"false"),

Also, is there a way to change the row column from a number to a count function (ie, 3 = A1, 4 = count(A1)+1). I'm not sure if I'm doing this right.


Thanks everyone.