|
Featured Tutorial
Featured Macro
Highline Excel Class 43: MATCH function
Match function tricks:
1)Find ordinal position (relative position) of an item in a list
2)Is item in list one in second list formula: MATCH & ISNUMBER
3)Is item in list one not in second list formula: MATCH & ISNA
4)MATCH is really for use with INDEX function
This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109
1)Find ordinal position (relative position) of an item in a list
2)Is item in list one in second list formula: MATCH & ISNUMBER
3)Is item in list one not in second list formula: MATCH & ISNA
4)MATCH is really for use with INDEX function
This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109