Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
It's actually quite easy to do with a lookup function. The VLOOKUP and HLOOKUP functions, together with INDEX and MATCH, are some of the most useful functions in Excel. Note: The Lookup Wizard feature is no longer available in Excel. Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE)
Excel video training - Microsoft Support
A list of Excel training, from entry level to advanced skills, plus templates and other resources.
Combine text from two or more cells into one cell
Combine text from two or more cells into one cell. You can combine data from multiple cells into a single cell using the Ampersand symbol (&) or the CONCAT function. Combine data with the Ampersand symbol (&) Select the cell where you want to put the combined data. Type = and select the first cell you want to combine.
Using IF with AND, OR, and NOT functions in Excel
In Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False. =IF (Something is True, then do something, otherwise do something else)
VLOOKUP function - Microsoft Support
How to correct a #N/A error in the VLOOKUP function. Look up values with VLOOKUP, INDEX, or MATCH. HLOOKUP function. 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.
Using wildcard characters in searches - Microsoft Support
Use wildcard characters as comparison criteria for text filters and when you're searching and replacing content. These can also be used in the Conditional Formatting rules that use the "Format cells that contain specific text" criteria.
Create conditional formulas - Microsoft Support
Create conditional formulas. Excel for Microsoft 365 Excel 2024 Excel 2021 Excel 2019 Excel 2016. Testing whether conditions are true or false and making logical comparisons between expressions are common to many tasks. You can use the AND, OR, NOT, and IF functions to create conditional formulas.
Using structured references with Excel tables - Microsoft Support
When you add formulas to an Excel table, those names can appear automatically as you enter the formula and select the cell references in the table instead of manually entering them. Here's an example of what Excel does: That combination of table and …
Basic tasks in Excel - Microsoft Support
Let’s go through the basic steps to get you started. Get started with basic tasks in Excel such as opening a workbook, entering and formatting data, calculating data, and trying some quick analysis features..
Excel functions (alphabetical) - Microsoft Support
Overview of formulas in Excel. How to avoid broken formulas. Detect errors in formulas. A complete list of all Excel functions in alphabetical order.
IF function - Microsoft Support
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.