Dueling Excel 035


3 Way Lookup INDEX or OFFSET function?

DESCRIPTION

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!

WORKBOOKS