The col_index_num indicates which column in that data area to then select from. How VLOOKUP works is very simple: Excel takes the lookup_value (-22%) and looks down the first column of the table_array (-100%, -15%, 0%, 10%, 20%) until anbsp;...
|Title||:||The Investment Banker's Handbook: Financial Modelling: A Practical Manual for Using Excel in Financial Modelling|
|Author||:||Corporate Training Group (CTG)|
|Publisher||:||ILX Group plc -|