VLOOKUP script download - VLOOKUP VLOOKUP - vlookup tutorial

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]Note: the code consist of three different versions of vlookup, the fastest is only consist of two lines code uncommented. Requirements: · MATLAB Release: R10

RECOMMENDED TOOLS

» matlab VLOOKUP » matlab mathematics » VLOOKUP mathematics » matlab » VLOOKUP » mathematics

Derivative script      
Derivative Derivative provides the first derivative using a 2nd order difference method.
Price: Freeware$, Rating: 10, Downloads: 0

First-Order Degree Linear Differential Equations script      
First-Order Degree Linear Differential Equations First-Order Degree Linear Differential Eq
Price: Freeware$, Rating: 6, Downloads: 0

Entrop script      
Entrop Entrop implements a special version of the algorithm for entropy maximization.
Price: Freeware$, Rating: 8, Downloads: 0

Hybrid Symbolic and Numerical Simulation script      
Hybrid Symbolic and Numerical Simulation Hybrid Symbolic and Numerical Simulation - Matlab
Price: Freeware$, Rating: 10, Downloads: 0

Math Function in 3D Graphics script      
Math Function in 3D Graphics Math Function in 3D Graphics code allows you to have a 3D rep
Price: Freeware$, Rating: 6, Downloads: 0

matlab scm script      
matlab scm matlab scm - Robotic Manipulator Kinematics
Price: Freeware$, Rating: 10, Downloads: 0

Gauss Quadrature for Tetrahedra script      
Gauss Quadrature for Tetrahedra Gauss Quadrature for Tetrahedra - Compute Gauss weights an
Price: Freeware$, Rating: 10, Downloads: 0

com.wis.math.alg.Matrix script      
com.wis.math.alg.Matrix com.wis.math.alg.Matrix implements the behaviours of the Matrix Cl
Price: Other Free / Open So$, Rating: 9, Downloads: 0