Forum Discussion
Solved
M365 Copilot in Excel: VLookUp
Has anyone successfully had M365 Copilot perform a VLookUp? If so how was the prompt written?
- Copilot in Excel can only reference a single table and sheet at this time.
During the Ignite Copilot overview for Excel in Nov 2023 there was mention that there is a backlog/roadmap item to expand the ability in Excel to allow users to leverage more than one table.
Take a look at the roadmap site here https://www.microsoft.com/en-gb/microsoft-365/roadmap?filters=&searchterms=Copilot
2 Replies
- Copilot in Excel can only reference a single table and sheet at this time.
During the Ignite Copilot overview for Excel in Nov 2023 there was mention that there is a backlog/roadmap item to expand the ability in Excel to allow users to leverage more than one table.
Take a look at the roadmap site here https://www.microsoft.com/en-gb/microsoft-365/roadmap?filters=&searchterms=Copilot
