XLOOKUP function 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.

To get started, select the Start button, and then select Calculator in the list of apps. Select the Open Navigation button to switch modes. Use Standard mode for basic math, Scientific for advanced calculations, Programmer for binary code, Date calculation for working with dates, and options under Converter for converting units of measurement.

Create a document in Word for the web With Word for the web running in your web browser, you can: Create documents to add and format text, images, and page layouts. Get to your documents from your computer, tablet, or phone. Share and work with others, wherever they are.

Discover how to effectively utilize your computer keyboard and master various keyboard shortcuts for efficient computing.

The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False. For example, =IF (C2=”Yes”,1,2) says IF (C2 = Yes, then return a 1 ...

To view SharePoint files in File Explorer, we recommend first making the SharePoint files available in the folders on your device. To do so, whether you're using Chrome, Microsoft Edge, or another browser, you can use either Add shortcut to My files or Sync. In comparison to View in File Explorer command method, these two methods are faster and ...

Learn how to install Windows 7 Service Pack 1 (SP1). Includes info about how to get the download, requirements, and more.

The new Bing is now available to everybody directly from the Windows taskbar, making more ways to interact with your PC across search, answers, chat, and creation available anytime, right on your desktop.

In Office 2021, you'll find new co-authoring features, inking tools, data types, functions, translation and editing tools, motion graphics, ease-of-use features, and so much more! Check out what's available to you today.

Learn how you can free up drive space in Windows. Keep your PC running smoothly and up to date by increasing the disk space.