Quote:
Originally Posted by Bretai2k
Concatenate might be what I am looking for, but I'm trying to understand what the Plan2 are referencing. When I plug it in, it asks me to update values and then I get #N/A? for the two Plan2s that are referenced after the MATCH function.
|
Dear
Bretai2k, Good Evening.
I´m sorry!
As my Excel is in Portuguese the sheet here is called Plan.
I forgot to change this for you.
Try this one now.
=SUM(INDIRECT(CONCATENATE("Sheet2!$B",MATCH(A2,She et2!$B$2:$B$75,0)+1,":$B",MATCH(B2,Sheet2!$B$2:$B$ 75, 0)+1)))
Have a nice day.