Goal: We want to calculate the respective IRR for each entity on the summary sheet. Each entity contains its own worksheet, thus we need to dynamically reference the XIRR formula based on the individual worksheet name.

This is a follow-on to an earlier video on the XLOOKUP function across worksheets.

Download Spreadsheet Vault SpreadsheetVault – XIRR formula across multiple sheets (solution).xlsb