Index function in Excel

Hello all. In this section, let’s explore the Index function. Index is a commonly used function that returns the value of cell at the intersection of specified row and column. In a given range if row and column number is provided, the function returns the value at the intersection. Syntax: =Index(array,row_num,[column_num]) =Index(reference, row_num, [column_num], [area_num]) … Read more

Random Name / text picker – with Index function

Hello all. We have already seen random name picker here – there we used the CHOOSE function. Let’s see how to use generate random name (text) using the INDEX function. Index function returns the value of the cell at an intersection of specified row and column. With Index as the base, we shall see how … Read more