How to use the HLOOKUP Function
When you start learning about the lookup functionality of Excel, HLOOKUP will probably be one of the first functions you will stumble upon.
1704, 2019
Tag Archives: Reference
1704, 2019
How to use the VLOOKUP function
When you start learning about the lookup functionality of Excel, VLOOKUP will probably be one of the first functions you will stumble upon.
1704, 2019
How to use the OFFSET function
One very useful Excel function is OFFSET. It returns a range of cells which corresponds to a specified number of rows and columns starting at a given distance from a reference cell.
1704, 2019
How to use the MATCH function
There is no way to create a powerful and versatile lookup formula without using at least once the MATCH function.
0504, 2019
The TRANSPOSE Function
The TRANSPOSE function transposes (rotates) a range of cells.
We can transpose our data by using the relevant Paste Special option also but it will create duplicate data.
