Ashvi City - Mr. Excel

MATCH Function:       Summary The  MATCH  function searches an item in a range of cells and then returns the relative position of that item in the range. For example, if the range is H4:H7 contains the values SONU, PAWAN, HARUN, and RITTULBHAI, then the formula =MATCH("HARUN",$H$4:$H$7,0) returns the number 3 because HARUN is the third item in the range. Trick Tip : You can use the MATCH function to provide a value for the row_num argument of the INDEX function, using this function you don't need to write numbers manually. So, advise you to use this MATCH function with INDEX function, VLOOKUP , HLOOKUP, etc. First will let you know about the purpose and syntax of the same.   Purpose The MATCH function can use to searches an item in a range of cells and then returns the relative position of that item in the range. Arguments & Syntax     As given above syntax contain 3 different arguments, meaning of the ...

HLOOKUP FUNCTION: Summary HLOOKUP is one of the most powerful tools in Excel. The HLOOKUP function enables you to look up data corresponding with the row of a lookup value and corresponding row index. It sounds like a very simple thing, and it is. For example, the HLOOKUP function can use the relational data essentials of two separate tables and affix the data from one table to the other table. you can create a simple Excel table that uses HLOOKUP to lookup and present data from one or other tables. Don’t worry if it’s sound little difficult, by the end of this article, you will be able to teach others about the HLOOKUP. First will let you know about the purpose and syntax of the same. Purpose The HLOOKUP function can use the relational data essentials of two separate tables and affix the data from one table to the other table. Arguments & Syntax This function  syntax contain 4 different arguments, meaning of the same is given below. ...

Hi All, This video and article wrote on   VLOOKUP  and  COLUMNS  will help you to learn an ADVANCE VLOOKUP function. This video will help in writing Vlookup in multiple cells at once, if I would say in a simple language then this video watching time is a BLASTING movement for excel users. VLOOKUP basis already explained VLOOKUP ARTICLE  and  COLUMNS ARTICLE

COLUMNS Function: Summary COLUMN  function returns the count of columns selected. First will let you know about the purpose and syntax of the same. Purpose To get the number of columns in an array or selected table range. Arguments & Syntax =COLUMNS(A5:C6) =COLUMNS(array) As given above syntax contain 1 argument, the meaning of the same is given below. Arguments Meaning array In this function selected columns are array, does not matter the same is only columns, columns along with row’s or any data filled table. Translation COLUMNS function we can use to know the column count for the selected range or reference. Selected range can be only columns, can be columns and row’s or any other data filled table bur function will return only columns count. Example:1 Range selected: =(COLUMNS(A5) ...