View License

Download apps, toolboxes, and other File Exchange content using Add-On Explorer in MATLAB.

» Watch video

Highlights from
VLOOKUP

Join the 15-year community celebration.

Play games and win prizes!

» Learn more

3.0
3.0 | 3 ratings Rate this file 1 Download (last 30 days) File Size: 1.56 KB File ID: #12453 Version: 1.0

VLOOKUP

by

 

29 Sep 2006 (Updated )

vlookup tutorial

| Watch this File

File Information
Description

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.

Acknowledgements

Vlookup Similar To Ms Excel Function inspired this file.

MATLAB release MATLAB 5.2 (R10)
MATLAB Search Path
/
Tags for This File   Please login to tag files.
Please login to add a comment or rating.
Comments and Ratings (4)
16 Mar 2008 ruchit chaturvedi

I agree with Jeff. Have to be very careful since the function does not give the exact match.

10 Jul 2007 FATEN SOLTANI

comment pouvant savoir ? quelle couleur correspond une valeur de pixel

Comment only
28 Feb 2007 Jeff H

This doesn't do what a vlookup does, at least the most commonly used (exact match) version. In your example, if I vlookup(1.5,lut,2) I should get back a NaN - 1.5 is not an element of lut(:,1). However your function would interpolate and yield 0.6. Dangerous!

01 Oct 2006 KALAI KOVAN  
Updates
31 Mar 2016 1.0

update the license

Contact us