Nz | search
Click here to view Nz news from 60+ newspapers.
Bookmark or Share- Create a parameter query (Power Query) - Microsoft SupportHowever Power Query parameters have key differences: Parameters can be used in any query step. In addition to functioning as a data filter, parameters can be used to specify such things as a file path or a server name. Parameters don’t prompt for input. Instead, you can quickly change their value using Power Query.
- LOOKUP function - Microsoft SupportUse LOOKUP, one of the lookup and reference functions, when you need to look in a single row or column and find a value from the same position in a second row or column. For example, let's say you know the part number for an auto part, but you don't know the price.
- INDIRECT function - Microsoft SupportHow to use the INDIRECT function in Excel to change the reference to a cell within a formula without changing the formula itself.
- Look up values with VLOOKUP, INDEX, or MATCH - Microsoft SupportHere'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.
- Append queries (Power Query) - Microsoft SupportIn Power Query, the Append operation creates a new query that contains all rows from a first query followed by all rows from a second query.
More
