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
vlookup tutorial
This is matrix version of VLOOKUP similar to MS Excel function.Return matrix b which has equal size as m and the values are taken fromfrom the n column of lookup table lut. It will replace all NaN
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
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