Excel Forum
Similar Content
Find the Most Frequently Occurring Value in a List in Excel
Tutorial: Use a formula to return the most frequently occurring word or value from a range of cells...
Best Lookup Formula in Excel - Index and Match
Tutorial: A lookup using INDEX and MATCH is like a VLOOKUP without the restrictions.  Index and Mat...
Dynamic Formulas that Update When you Add Data in Excel
Tutorial: I'll show you how to make formulas and functions that automatically update when more data...



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.