Excel Forum

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.