Excel Forum
Similar Content
Excel VBA - Create an Array - 3 ways
Tutorial: Ill show you three different ways to create an array in Excel VBA and Macros and how to ge...
OFFSET Function in Excel
Tutorial: The OFFSET function in Excel returns a cell or range reference that is a specified number...
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...



Mr Excel & excelisfun Trick 35: 3 Way Lookup INDEX or OFFSET function?


See Mr Excel and excelisfun do a three way lookup. Compare a method that uses INDEX, MATCH and OFFSET function to a second method that uses INDEX and MATCH but instead of the OFFSET we use a second INDEX with a zero row argument!

PodCast 1139 or Mr Excel excelisfun video 35





Got a Question? Ask it Here in the Forum.