XIRR with Variable Ranges and Non Contiguous Data

I'm Googling in circles today trying to figure out a solution to the attached. In column H, I am trying to calculate the IRR (using XIRR) if the Future Inflow (B3) were to be received on the date for each row. I can run the XIRR using offsets, but it doesn't bring in the final future inflow because it is not inline with the other cashflows and dates. The "Years" column (column G) is servicing as a reference for the offset formulas I've been toying with. The example formula in H9 is missing the necessary inflow from B3. In my mind, I am trying to create a formula that does the following: =XIRR((OFFSET($F$8,0,0,G9,1)~AND THE ONE VALUE THAT IS LOCATED IN B3~),OFFSET($E$8,0,0,G9,1)~AND THE ONE DATE THAT IS LOCATED IN THIS SAME ROW~,0.1). Any help is greatly appreciated.