Include | search
Click here to view Include news from 60+ newspapers.
Bookmark or Share- XLOOKUP function - Microsoft SupportUse 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.
- Select data for a chart - Microsoft SupportLearn best ways to select a range of data to create a chart, and how that data needs to be arranged for specific charts.
- Using IF with AND, OR, and NOT functions in ExcelIn 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.
- Check if a cell contains text (case-insensitive) - Microsoft SupportIf you have no concern for upper- or lowercase text, there are several ways to check if a cell contains text. You can also use a filter to find text. For more information, see Filter data. Follow these steps to locate cells containing specific text: Select the range of cells that you want to search. To search the entire worksheet, click any cell.
- Using wildcard characters in searches - Microsoft SupportUse wildcard characters as comparison criteria for text filters, and when you're searching and replacing content. This feature enables you to find values that share a simple pattern. These characters can be the asterisk (*), the question mark (?), and the tilde (~).
More
