MATCH Formula MATCH formula searches for a value in an array and returns the relative position of that item. Syntax for Match formula MATC...

  VLOOKUP by cell background color In this article you will learn how we can use  VLOOKUP  by a cell background color. We will create a  Use...

  INDEX Formula INDEX formula returns a value in a table based on the intersection of a row and column position within that table. Syntax fo...

6 Powerful Dynamic Array Function in Excel In this article, we have explained 6  Dynamic Array  functions in  Microsoft Excel . Dynamic Arra...

  HLOOKUP-Formula HLOOKUP formula performs a horizontal lookup by searching for a value in the top row of the  table  and returning the valu...