Excel Forum

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.

Got a Question? Ask it Here in the Forum.