Dueling Excel 035

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!


Be the first to comment

Leave a Reply