What is Excel LOOKUP function ?
LOOKUP function is one of the lookup and reference
… Read MoreVLOOKUP function: Description, Usage, Syntax, Examples and Explanation
What is VLOOKUP function in Excel?
VLOOKUP function is one of the lookup and reference … Read More
MATCH function: Description, Usage, Syntax, Examples and Explanation
What is MATCH function in Excel?
MATCH function is one of Lookup and Reference functions … Read More
CHOOSE function: Description, Usage, Syntax, Examples and Explanation
What is Excel CHOOSE function?
INDEX function: Description, Usage, Syntax, Examples and Explanation
What is INDEX function in Excel?
INDEX function is one of Lookup and Reference functions … Read More
Create hyperlink with VLOOKUP in Excel
To create a hyperlink from a lookup, you can use the VLOOKUP function together with … Read More
How to calculate two-way lookup VLOOKUP in Excel Table
To do a two-way lookup in an Excel Table, you can use the MATCH function … Read More
To count total rows in a range in Excel
If you need to count the number of rows in a range, use the ROWS … Read More
Last row number in range
You can get the last row in a range with a formula based on the … Read More
How to get last row in text data in Excel
To get the last relative position (i.e. last row, last column) for text data (with … Read More
How to get last row in numeric data in Excel
To get the last relative position (i.e. last row, last column) for numeric data (with … Read More
How to get last row in mixed data with blanks in Excel
To get the last relative position (i.e. last row, last column) for mixed data that … Read More
How to get last column number in range in Excel
You can get the last column in a range with a formula based on the … Read More
How to get relative row numbers in a range in Excel
To get a full set of relative row numbers in a range, you can use … Read More
How to get relative column numbers in a range in Excel
This tutorial shows how to get a full set of relative column numbers in a … Read More
How to get address of last cell in range in Excel
To get the address of the first cell in a named range, you can use … Read More
How to get address of named range in Excel
To get the full address of a named range with an Excel formula, you can … Read More
How to get first row number in range in Excel
You can get the first row (i.e. the starting row number) in a range with … Read More
How to get first column number in range in Excel
You can get the first column (i.e. the starting column number) in a range with … Read More
How to retrieve first match between two ranges in Excel
To retrieve the first match in two ranges of values, you can use a formula … Read More
How to create dynamic named range with OFFSET in Excel
One way to create a dynamic named range with a formula is to use the … Read More