Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work. For VLOOKUP, this first argument is the value that you want to find. This argument can be a cell reference, or a fixed value such as "smith" or 21,000.

If some Windows functions aren't working or Windows crashes, use the System File Checker to scan Windows and restore your files. Though the steps below might look complicated at first glance, just follow them in order, step-by-step, and we’ll try to get you back on track.

This article describes the keyboard shortcuts, function keys, and some other common shortcut keys in Excel for Windows. Notes: To quickly find a shortcut in this article, you can use the Search. Press Ctrl+F, and then type your search words.

A list of Excel training, from entry level to advanced skills, plus templates and other resources.

Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.

If you have a worksheet with data in columns that you need to rotate to rearrange it in rows, use the Transpose feature. With it, you can quickly switch data from columns to rows, or vice versa.

Find and apply a template. Get started with basic tasks in Excel such as opening a workbook, entering and formatting data, calculating data, and trying some quick analysis features..

Use the Add a language feature to install another language for Windows 11 to view menus, dialog boxes, and supported apps and websites in that language. To do this: Select Start > Settings > Time & language > Language & region.

Create and format a hard disk partition. To create a partition or volume (the two terms are often used interchangeably) on a hard disk, you must be logged in as an administrator, and there must be either unallocated disk space or free space within an extended partition on the hard disk.

Training: Watch and learn how to create a PowerPoint presentation, add/format text, and add pictures, shapes, and/or charts.