MATCH function performs lookup for a value in a range and returns its position sequence number as output. It has two required and one optional arguments