In this tutorial we are going to look at a typical INDEX / MATCH combination formula but with a twist that concatenates both the lookup values and the arrays that are being looked into, making it an array formula.
Tag Archives | Concatenate
In this tutorial we are going to look at the undocumented function in Excel DATEDIF. This could be a great tool to dynamically calculate the number of years, months and days between two dates.
In this tutorial we’ll take a look at how to add a column with a formula outside of our PivotTable for project analysis that pulls results from a Table, then use Conditional Formatting to dress it up.
In this video, we will look up two values in cells A1 & B1, find a match in two other columns of data and return a result from a third column from that same matching row. We will utilize the INDEX and MATCH functions while using Array formulas in the process.
In this post I will use the Consolidate Multiple Ranges option to concatenate table headers wtih the column values…..