Transpose (rotate) data from rows to columns or vice versa
How to use Transpose in Excel to rotate columns and rows to rearrange your worksheet data.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
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, …
ROW function - Microsoft Support
The ROW function in Excel returns the row number of a reference you enter in a formula. For example, =ROW(C10) returns row number 10. You can't use this function to insert or remove a …
LOOKUP function - Microsoft Support
How to use the LOOKUP function in Excel to search in a single row or column and find a value from the same position in a second row or column.
TRANSPOSE function - Microsoft Support
Sometimes you need to switch or rotate cells. You can do this by copying, pasting, and using the Transpose option. But doing that creates duplicated data. If you don't want that, you can type …
INDEX function - Microsoft Support
Returns the value of an element in a table or an array, selected by the row and column number indexes. Use the array form if the first argument to INDEX is an array constant. Syntax. …
Move or copy cells, rows, and columns - Microsoft Support
You can use the Cut command or Copy command to move or copy selected cells, rows, and columns, but you can also move or copy them by using the mouse. By default, Excel displays …
Using structured references with Excel tables - Microsoft Support
To include structured references in your formula, click the table cells you want to reference instead of typing their cell reference in the formula. Let’s use the following example data to …
Context in DAX Formulas - Microsoft Support
Row context automatically follows the relationships between tables to determine which rows in related tables are associated with the current row. For example, the following formula uses the …
Create a drop-down list - Microsoft Support
You can insert a drop-down list of valid entries (also called a drop-down menu or drop-down box) in Excel to make data entry easier, or to limit entries to certain items that you define.
Apply shading to alternate rows or columns in a worksheet
One way to apply shading to alternate rows or columns in your worksheet is by creating a conditional formatting rule. This rule uses a formula to determine whether a row is even or odd …