In this video I have explain in detailed about Ms Excel Lookup & Reference Group Function #MATCH()br MATCH is used to locate the position of a lookup value in a row or column. This Function supports approximate and exact matching, and wildcards (* ?) for partial matches. if we combined MATCH Function with #HLOOKUP, #INDEX, OFFSET, VLOOKUP, its get so powerful and return the various type of result, we can say its a versatile Function of Excel.br br To Know in detailed Watch this video till the end.