|
Featured Tutorial
Featured Macro
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
PodCast 1139 or Mr Excel excelisfun video 35