Created by David Moore, PhD
Reference Material: Wall Street Prep Excel Crash CourseFV = Future Value
PV = Present Value
r = Interest rate
t= number of periods
$(1+r)^t$= the future value factor
Will look the a given value in the first row of a given table array and return the value in the specified row. Replace row value with MATCH function to make fully dynamic. If looking up text, set RANGE_LOOKUP to false for an exact match
Will look the a given value in the first column of a given table array and return the value in the specified column. Replace column value with MATCH function to make fully dynamic. If looking up text, set RANGE_LOOKUP to false for an exact match
Given a location (reference) will count x rows down and y columns to the right. Set reference to top left corner of the table and use MATCH to output ROWS and COLS (will need to subtract 1)
Given an array will return the value at the location of the given row and column. Use MATCH to output ROW_NUM and COL_NUM
Returns the row (column) location of a given value in an array. Set MATCH_TYPE to 0 for an exact match.