Copilot makes lookups in Excel easy

Copilot

Hello,

Select a different account.

You have multiple accounts

Choose the account you want to sign in with.

Copilot makes lookups in Excel easy

Applies To

Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web

In Excel you can have Copilot help you create cells that look up a value elsewhere in your workbook and return a corresponding value.

A sample price list of toys in Microsoft Excel.

How to create a lookup with Copilot in Excel

In the prompt box ask Copilot to create your lookup column. Try a prompt like this:

Document with sparkles Create a column that looks up the quantity in stock for each item from the inventory sheet.

Copilot will look over your data and recommend a formula that looks up the stock and inserts it in your price list.
Copilot has recommended an XLookup formula that looks up the stock quantity from the Inventory sheet and inserts it here on the price list. Select +Insert Column to add the column to your price list sheet.