Q) what is the excel equivalent of matlab's ismember function
A) vlookup
The syntax is vlookup(lookup_value, table_array, col_index_num, [range_look_up])
It can be used to check if a value exists in a column, compare two columns etc.,
The col_index_num starts from 1.
I usually give the 4th argument as false, so I can get an exact match. See help in excel for more details.
ISNA() - similar to matlab's isnan function, is another function that comes in handy with vlookup. It tells whether a number is #N/A or not.
Malayamarutham is a mellifluous raaga in carnatic music which will make one soft at heart. In telugu, malaya maarutham is a cool evening breeze which invigorates mind, body & heart.
Feedback, suggestions, criticisms, typos, mistakes, errors etc., (no matter how small you think they are) on the articles of this blog are very welcome. They can be directed to kamaraju at gmail dot com.
Search This Blog
Showing posts with label excel. Show all posts
Showing posts with label excel. Show all posts
Sunday, March 11, 2012
Subscribe to:
Posts (Atom)