VLOOKUP

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 from
from the n column of lookup table lut. It will replace all NaN with zero.

example how to use:
Type this 2 matrix data

> m = [ 1 2 0; 3 4 1]
> lut = [0 0.5 12; 1 0.8 25; 2 0.4 32; 3 0.7 41]

produces
m = [ 1 2 0;
3 4 1]
lut = [0 0.5 12;
1 0.8 25;
2 0.4 32;
3 0.7 41]
> b=vlookup(m,lut,3)
=> [25 32 12;
41 0 25]

> b=vlookup(m,lut,2)
=> [0.8 0.4 0.5;
0.7 0 0.8]

Written by Kardi Teknomo http://people.revoledu.com/kardi/

Note: the code consist of three different versions of vlookup, the fastest is only consist of two lines code uncommented.