Tag: excelhelp.in

Mar172020 by excelhelp132 Comments

MATCH Function In Excel

MATCH function is used to find a specified reference value position in a range of cells, and then returns the position of that reference value. Always remember that match function only take a single column or single row as a lookup array(range). Match parameter ( Lookup Value, Lookup array, 0 (For exact match) ) (1) FOR COLUMN DATA Example given below in image. FORMULA COLUMN: =MATCH(B2,A2:A4,0) (2) FOR ROW DATA Example given below in image. FORMULA ROW: =MATCH(B2,B1:D1,0)

Mar162020 by excelhelp13No Comments

MID Function In Excel

FORMULAS, Text

MID function in excel is text function which is used to find out strings from any mid part of the sentence in excel. Mid function require the cell reference from which the text need to be extract, start number from which character need to be start , and number of character which need to be extract. NOTE: This function count the space too. So in the result it will include a space too. FORMULA: =MID(B2,7,4)