Key Takeaways. Understand the purpose of the INDEX function: It returns the value of a cell in a specified row and column within a range. Learn the MATCH function: It searches for a specified ...

And, the INDEX-MATCH functions used together make extracting data from a table a breeze. The syntax for the INDEX function is: INDEX(array, row_num, [column_num]).

That trick is Index/Match, a function that can find any value in any spreadsheet. ... the function finds "Eric" in the 9th row of column A, then returns the value in the fourth column, his age.

Microsoft Excel's CHOOSECOLS and CHOOSEROWS functions are a game-changer if you want to quickly extract specific columns or rows from your data without nesting several functions in your formula ...

TEXTSPLIT() parses, or “splits,” strings using column and row delimiters, much in the same way Microsoft’s Text To Columns feature works with columns, but in a function.