need YOY growth Formula

[ushaanu]

Hi all,

I need formal for calculate YOY Growth of my branches have 2017 data and 2016 now I need when I Select one branch auto match the 2016 month and calculate 2017 month yoy growth .

pls find the base file.

 

[vletm]

ushaanu - something like this for cell C3 and copy down
=IFERROR((B3-VLOOKUP(A3,J$4:N$15,MATCH(B$2,$J$3:$N$3,0),FALSE))/VLOOKUP(A3,J$4:N$15,MATCH(B$2,$J$3:$N$3,0),FALSE),"none")

 

[ushaanu]

Thank you vletm ,it`s working ..