Use the XLOOKUP function when you need to find things in a table or a 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.

Issues that are fixed in this update. The following issues are fixed for .NET Framework 4.7.2. SQL Server (SQL) Fixes an issue in which the .NET Framework API SqlConnection.ConnectionString property is used to set a null or empty connection string. In this situation, a Null Reference Exception (NRE) occurs when you use the API together with .NET Framework 4.7.2.

Do one of the following: If you've never used Easy Connect, select Use Easy Connect.. If you've used Easy Connect before, select your helper’s contact name. To invite someone who isn't on your contact list, select Invite someone to help you.

Here are some solutions to common problems with the new Microsoft Edge . If Microsoft Edge keeps crashing. If you can't open Microsoft Edge, or if it opens briefly and then closes, or if you’re unable to open specific webpages, here are some things you can try.

To find downloads on your PC: Select File Explorer from the taskbar, or press the Windows logo key + E.

If you're unable to open and view the notebook in OneNote for the web, the source of the sync problem is likely with your server. If your notebook is stored on OneDrive, check our Service Status page for any known interruptions or outages. If your notebook is stored on SharePoint, you'll need to contact your administrator to report and troubleshoot the problem.

Make text bigger on your screen. If the text size feels too small when navigating through Windows, you can make the text bigger. This affects, for example, title bars, menus, and icon texts.

Note: If you have previous activity history stored in the cloud before Windows 11 23H2 and 22H2, January 23, 2024-KB5034204 update, you can use the Clear activity history button to delete previously stored data in the cloud. Otherwise, your activity history will be automatically deleted within 30 days from when your data was last synced to the cloud

To capture a video snip, open Snipping Tool, select the Record button, then select New recording, or press Windows logo key + Shift + R.Select the area of the screen you wish to record, then select Start.When you are done, select Stop.At this point you can save the recording as-is or select Edit in Clipchamp to work with it in the Clipchamp video editor.

If you can't sign into your Microsoft account, most issues can be identified by our sign-in helper tool. The tool will ask you to enter the email address or mobile phone number you're trying to sign in with and check the details you provide.