Record-keeping or Book-keeping is an integral part of any business that wants to grow and succeed. There are different parts to record-keeping and in this video, I will show you how to maintain a Credit Purchase Book in Excel. The Credit Purchase Book is an Excel template that helps you track all credit purchase transactions …
The INDEX function returns a specific value from a one-dimensional or two-dimensional range. The MATCH function returns the relative position number of an item. The INDEX function actually returns the value in the cell, not the position. Let’s examine the INDEX function syntax below =INDEX (array, row_num, [column_num]) The array (First argument) is the range …
The MATCH function returns the position of a value in a given range. Let’s examine the function syntax =MATCH(lookup_value, lookup_array, [match_type]) lookup_value is the first argument in the Function syntax. It can be a cell reference, value or text string. lookup_array is the second argument in the function syntax. This is the cell range to …
The VLOOKUP function is used to look up values in a cell range and returns a value that is in the same row as the specified lookup value. Let’s examine the function syntax for better understanding: =VLOOKUP(Look_value, table_array, Col_index_num, [range_lookup]) The Look_value is the first argument in the VLOOKUP syntax above – this the value …
