% Increase/Decrease between two cells in two columns

[bweisman12]

Hello,
Please see the table below:

Store Name	Sales 2018	Rank	Store Name	Sales 2019	Rank
Store A	700	1	Store B	400	1
Store B	500	2	Store A	350	2

<tbody>
</tbody>

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