Transform Office 365 Excel sheet with XLookup to make compatible with old versions of Excel

I have an Excel sheet that uses XLookup formulas to calculate numerous values in certain columns based upon other values in the sheet. There are other people working on the Excel that do not have the version that I am working on and do not have access to use the XLookup formula. I need a replacement sheet that behaves identical. You are free to use Macros/VBA but it must be non-interactive (automatically calculate the values).

--> Acceptance criteria is that the sheet looks and behaves exactly like the original one and opens in an older version of Excel