### Excel Magic Trick 341 Extract Data w OFFSET & INDEX function

See the INDEX and MATCH function work together to retrieve a cell reference that the OFFSET function can use for its reference argument. See how to extract a small table of data from a list of data using 2 different formulas: 1)an OFFSET / INDEX / MATCH array formula 2)an INDEX / SMALL / IF / ROWS function array formula.

Length:
05:48