A complete vlookup function, similar to MS Excel function, which works both with matrices and tables and with any type of lookupvalue.
This function should work as the vlookup function in Excel vlookup looks for the 'look up value' in the 'luv-column'-th column of 'matrix_table' and return the corresponding 'mt_col'-th element of
A matrix version of VLOOKUP similar to MS Excel function.
VLOOKUP the function as vlookup in Excel [content, index] = vlookup(m, e, column, lookcolumn) look for 'e' in the 'lookcolumn'-th column of 'm', and return the coresponding 'column'-th element
Combines two spreadsheets with different row headers using two row header matching techniques.
truncates the row name, assuming most the differences come after the first few characters. For instance, "Microsoft Corp Loan" & "Microsoft CL" A vLookup won't work. So the script truncates them both