In this example, I will use the XLOOKUP formula to generate a weekly profit in cell E4 based on the site stated in cell E2. The first step ... to speed up your Excel spreadsheets.