Use the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term and return a result from the same row in another column, regardless of which side the return column is on.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Learn how to update Windows to ensure your device operates smoothly and securely with the latest features.

Get more out of your email with Outlook.com. We've streamlined search to make it easier than ever to find what you're looking for. New features like Files and attachment previews let you see your pictures and files without leaving your inbox.

Argument name. Description. lookup_value (required). The value you want to look up. The value you want to look up must be in the first column of the range of cells you specify in the table_array argument. For example, if table-array spans cells B2:D7, then your lookup_value must be in column B.. Lookup_value can be a value or a reference to a cell.. table_array (required)

Buy stuff from Microsoft Store online (from your mobile device, on Xbox One, in the Microsoft Store app on your Windows 10/11 or Windows 8.1 device, or via the web).

Windows 11 automatically downloads and installs updates to make sure your device is secure and up to date. This means you receive the latest fixes and security updates, helping your device run efficiently and stay protected.

If you forgot your PIN and need to reset it, you can do so from the Windows sign-in screen. Look below the PIN text box: If you see I forgot my PIN , select it and follow the instructions to reset your PIN.If there are multiple accounts on the device, choose the one you need to reset.

2. Verify your identity. For your protection, Microsoft must verify your identity before you can proceed with resetting your password. Choose how you want to receive a verification code.

Find and download free templates to create documents like calendars, business cards, letters, greeting cards, brochures, newsletters, or resumes.