I am at wits end because this problem makes no sense!
The above formula works great except in 1 scenario: a rate of 82% on which the 2% is subtracted. The 2nd vlookup does not seem to see the 80% on the Grid. It sees it when it doesn't have to subtract and it sees it for every other number of the Grid--there are 10 lines on the grid and 91 other instances where the Grid works. Any suggestions as to why this won't work?
I have made sure the Historical Detail range includes the 2 instances and copied the formatting from other cells in the Grid.
On the Function Arguments window for the 2nd vlookup, is there a way to expand the items shown in the window?