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.

Swipe in from the right edge of the screen, and then tap Search.Or, if you are using a mouse, point to the lower-right corner of the screen, and then click Search.Type Command Prompt in the Search box, right-click Command Prompt, and then click Run as administrator.If you are prompted for an administrator password or for a confirmation, type the password, or click Allow.

Contact Microsoft Support. What's new. Surface Pro. Surface Laptop. Surface Laptop Studio 2. Surface Laptop Go 3. Microsoft Copilot. AI in Windows. Explore Microsoft products.

Select the cell in the worksheet where you want the drop-down list. Go to the Data tab on the Ribbon, and then Data Validation. Note: If you can’t select Data Validation, the worksheet might be protected or shared. Unlock specific areas of a protected workbook or stop sharing the worksheet, and then try step 3 again.

The following are required for this to work: A PC running Windows 11. An Android devices running Android 8.0 or later. Your Phone and your PC both need to be connected to Wi-Fi network. Make sure to have both your PC and Android device nearby, turned on, and connected to Wi-Fi network. Open Settings on your PC.

Tip: If your can't get the code by email or phone, you might be able to enter an email address that's different from the one you're trying to recover. Go to the Recover your account page and follow the prompts.

Click or tap anywhere in the page you want to delete, press Option+⌘+G. In the Enter page number box, type \page. Press Enter on your keyboard, and then select Close. Verify that a page of content is selected, and then press Delete on your keyboard. To remove blank pages in the middle or at the end of your document, see Delete a blank page.

If you're using a Microsoft 365 Family subscription that someone else shared with you, or if you have another type of Microsoft 365 subscription, you can't share your subscription with other people. Choose how you'd like to share. Select Email invite then enter their email and select Invite. Select Create link then select Copy link.

Swipe in from the right edge of the screen, and then select Settings > Change PC settings. Select PC and devices, and then select Lock screen. Turn off Swipe down on the lock screen to use the camera. Note: To keep the Camera app from using the camera, turn off the camera completely. Drag the app to the bottom of the screen and hold it there ...

Create Windows 11 installation media. On the Windows 11 software download page , select Create tool now and follow the instructions to install Windows 11. Warning: Microsoft recommends against installing Windows 11 on a device that does not meet the Windows 11 minimum system requirements.