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)
Create a parameter query in Microsoft Query
When you query data in Excel, you might want to use an input value - a parameter - to specify something about the query. To do this, you create a parameter query in Microsoft Query: Parameters are used in the query’s WHERE clause – they …
VLOOKUP function - Microsoft Support
Use VLOOKUP when you need to find things in a table or a range by row. For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID. In its simplest form, the VLOOKUP function says:
Define and use names in formulas - Microsoft Support
You can define a name for a cell range, function, constant, or table. Once you adopt the practice of using names in your workbook, you can easily update, audit, and manage these names. Select a cell. In the Name Box, type a name. Press Enter. To reference this value in another table, type th equal sign (=) and the Name, then select Enter.
Add a list box or combo box to a worksheet in Excel
When you want to display a list of values that users can choose from, add a list box to your worksheet. Create a list of items that you want to displayed in your list box like in this picture. Click Developer > Insert. Note: If the Developer tab isn't visible, click File > Options > …
Create and invoke a custom function - Microsoft Support
Create and invoke a custom function. A custom function uses the M formula language, takes a set of input values, and then returns a single output value.
Create a named range from selected cells in a worksheet
You can quickly create a named range by using a selection of cells in the worksheet. Note: Named ranges that are created from selecting cells have a workbook-level scope. Select the range you want to name, including the row or column …
Use the Name Manager in Excel - Microsoft Support
Use the Name Manager dialog box to work with all the defined names and table names in a workbook. For example, you may want to find names with errors, confirm the value and reference of a name, view or edit descriptive comments, or determine the scope.
More on data validation - Microsoft Support
Data Validation Input and Error Messages. You can choose to show an Input Message when the user selects the cell. Input messages are generally used to offer users guidance about the type of data that you want entered in the cell. This type of message appears near the cell.
Enter data manually in worksheet cells - Microsoft Support
You have several options when you want to enter data manually in Excel. You can enter data in one cell, in several cells at the same time, or on more than one worksheet at once. The data that you enter can be numbers, text, dates, or times. You can format the data in a variety of ways.
Add or remove items from a drop-down list - Microsoft Support
In this article, we'll show you how to do that depending on how the list was created. If you set up your list source as an Excel table, then all you need to do is add or remove items from the list, and Excel will automatically update any associated drop-downs for you. To add an item, go to the end of the list and type the new item.