Excel Forum
Similar Content
Best Lookup Formula in Excel - Index and Match
Tutorial: A lookup using INDEX and MATCH is like a VLOOKUP without the restrictions.  Index and Mat...
Return the Min or Max Value Using a Lookup in Excel - INDEX MATCH
Tutorial: Find the Min or Max value in a range and, based on that, return a value from another rang...
How to use the Vlookup Function in Excel
Tutorial: Full explanation of the Vlookup function in Excel, what it is, how to use it, and when you...



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





Got a Question? Ask it Here in the Forum.