% Increase/Decrease between two cells in two columns

[bweisman12]

Hello,
Please see the table below:

[TABLE="width: 700"]
<tbody>[TR]
[TD]Store Name[/TD]
[TD]Sales 2018[/TD]
[TD]Rank[/TD]
[TD]Store Name[/TD]
[TD]Sales 2019[/TD]
[TD]Rank[/TD]
[/TR]
[TR]
[TD]Store A[/TD]
[TD]700[/TD]
[TD]1[/TD]
[TD]Store B[/TD]
[TD]400[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Store B[/TD]
[TD]500[/TD]
[TD]2[/TD]
[TD]Store A[/TD]
[TD]350[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I am looking to do two things:

1. I need to find the difference in sales for Store A and Store B from 2018 to 2019 (So A would be -350 and B would be -100)

2. I need to find the % difference in sales for Store A and Store B from 2018 to 2019

Thank you for the help.

 

[Special-K99]

1. =e2-b2
2. =sign(e2-b2)*e2/b2*100

 

[bweisman12]

1. =e2-b2
2. =sign(e2-b2)*e2/b2*100

Thanks for the reply. However, please note that Store B is E2, not store A. The stores are sorted by rank and will not always line up. I need a function that will find the correct store to compare between 2018 and 2019.

 

[Special-K99]

Oh yep, seen it now.

in G2 (relating to A2)
1. =INDEX(E$2:E$3,MATCH(A2,D$2:D$3,0),0)-B2
in H2
2. =sign(INDEX(E$2:E$3,MATCH(A2,D$2:D$3,0),0)-B2-B2)*INDEX(E$2:E$3,MATCH(A2,D$2:D$3,0),0)-B2/B2*100