1. No. We don't have bi-directional support from an Excel sheet back to a list. 2. Not in the list. But you can export from a list into Excel and then apply formula; including ability to refresh data if you reuse the Excel. But again, you can't put data back to list from Excel. 3. You can lookup information from list to list if the lists reside in the same site collection. And the team is working to enable lookup of additional column types in the future. 4. Yo would need to use Power Automate to lookup and take action across lists, across sites: https://learn.microsoft.com/en-us/power-platform/admin/security/connect-data-sources Thanks for your feedback and time in joining the AMA. - Mark