Hi All,
I am attempting to obtain information (Interest Income) from my table array (F2:AS19). I need to change the "current rate" anywhere from .25% to 10%. I also want to be able to add the delta (50bps) to the current rate and thus correspond to the interest rates in the table heading. For example if the current rate is 8% and delta is 50bps the column the lookup should find is 8.5%.
The formula seems to work well for any current rate up to 1%, and once you choose a rate = to or > than 1% the cell returned from the vlookup is always the one to the left of what it should be. So in the earlier example where the lookup should be in the 8.5% column it actually chooses a number from 8.25% column.
Changing the last argument in the Hlookup from TRUE to FALSE returns an N/A for any number => than 1% but returns the correct number for the numbers below 1%.
Bookmarks