Learn Excel How to use the Match formula with the approximate and the exact options to lookup values. This Excel tutorial explains how to use the Excel MATCH function with syntax and examples.• The MATCH function does not distinguish between upper and lowercase when searching for a match. If the MATCH function does not find a match, it will return a #N/A error. If the match_type parameter is 0 and a text value, then you can use wildcards in the value parameter.
