Excel: Dynamic Column Reference Lookup


This attached Excel workbook contains a formula I use frequently to evaluate businesses that have multiple locations and a lot of data. The SUMIF(), INDEX() and MATCH() functions can be used together to dynamically call columns of information. The trick is to input a "0" in the INDEX() function for the value "row_num." This results in the function returning the entire column.

Read More Financial Model for Siemens AG»


We are processing your request.
Please wait.
Please do not refresh the page.