Indirect Formula

[alside]

-
Hi All,

I am trying to come up with a formula where we can change the "yellow" cells and the "green" cells will pull data from the table above, so the indirect formula will go in the green cells (see attached). I am not sure if this is a lookup or indirect fomula needed.

Thank you

[Limor_OP]

Hi,
why do you have 3 times "Prior" in the 1st table?

[alside]

Those would be the prior years, I eventually would need to sum those items to get the "Prior" amount for each table

[Limor_OP]

Hi,
You need to copy the titles from D14 to D15, D20 to D21, etc.

Then -
In F14 and down:
=SUMPRODUCT(OFFSET($D$2,MATCH(E14&$D14,$D$3:$D$10&$E$3:$E$10,0),2,,3))
G14 and across:
=INDEX($F$3:$R$10, MATCH($E14&$D14,$D$3:$D$10&$E$3:$E$10,0), MATCH(RIGHT(G$13,2),RIGHT($F$2:$R$2,2),0))

[Glenn Kennedy]

Alside, Please DO NOT remove your text and attachment when you have got a solution. That denies other users the possibility of benefitting from the FREE advice that you were given on this PUBLIC forum.

I have restored your text. Your attachment can be found on one of the replies to your post.


Be part of the Community, and don't expect it to operate for your private & exclusive benefit.