Sunday 29 July 2012

MS EXCEL

Problem 1: How to check if the values in colum A match with any of the values in column B?

Solution: Write this formula for column C =MATCH(A1, B$1:B$700,0) and drag down to 700th row.

param1: is the value which should be searched,
param2: is the range of cells in which it'll be searched for
param3: looks for exact match

Return value of this function is the index of the first cell in column B where the matched value is found.


More information about this is here