## Two-way lookup with VLOOKUP

Example Related FunctionsMATCH VLOOKUP =VLOOKUP(lookup_value,table,MATCH(col_name,col_headers,0),0)In most cases, people will hardcode the column index ...

## Two-way lookup with INDEX and MATCH

Example Related FunctionsINDEX MATCH =INDEX(data,MATCH(val,rows,1),MATCH(val,columns,1))To lookup in value in a table using both rows and columns, you ...

## Turn End mode on

Windows shortcut  End Mac shortcut  Fn→ This shortcut enables and disables "End mode". In End mode, arrow keys move you farther across the ...

## Transpose table without zeros

Example Related FunctionsIF TRANSPOSE =TRANSPOSE(IF(rng="","",rng))To dynamically transpose a table that contains blanks, you can use an array formula ...

## Total rows in range

Example Related FunctionsROWS =ROWS(rng)If you need to count the number of rows in a range, use the ROWS function. In the generic form of the formula ...

## Total hours that fall between two times

Example Related FunctionsMIN =IF(start<end,MIN(end,upper)-MAX(start,lower),MAX(0,upper-start)+MAX(0,end-lower))ContextYou have a start time and an ...

## Total columns in range

Example Related FunctionsCOLUMNS =COLUMNS(rng)If you need to count the number of columns in a range, use the COLUMNS function. In the generic form of ...

## Total cells in a range

Example Related FunctionsCOLUMNS ROWS =ROWS(rng)*COLUMNS(rng)If you need to count the total number of cells in a rectangular range, you can do so with ...

## Toggle scroll lock

Windows shortcut  ScrLk Mac shortcut  Fn⇧F14 This shortcut toggles Scroll Lock on and off. Note: the Scroll Lock status message may or may not be ...

## Toggle pivot table field checkbox

Windows shortcut  Space Mac shortcut  Space This shortcut will toggle check and uncheck the checkbox for fields listed in the pivot table field ...