I tried both and was unfortunately unsuccessful. I am totally confounded
by this seemily simple problem!

The lookup table, returned only the ', telling me that no matter what %
was referencing excel was just recognizing it as 0. The IF statement
returned 2 pts for a YOY % change of 146.3%, which was the same problem
I was running into initially.

Is excel perhaps referencing the value of the % change formula instead
of it's result?


--
stellarblue11