Hello,
=IF(VLOOKUP(A1117,'Historical Detail'!$A$2:$E$96,5,FALSE),VLOOKUP(J1117-0.02,Grid,2,FALSE),IF(ISNUMBER(MATCH(J1117,Payouta,0)),VLOOKUP(J1117,Grid,2,FALSE),VLOOKUP(J1117,OffGrid,2,FALSE)))
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?
Thank you.
Pat
Open in new window
Saurabh...