Excel Forum
Similar Content
Simple User Input Prompts in Excel
Tutorial: The easiest way to tell a user to input a value into a field before they can continue. Th...
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 Ma...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.