The function XMATCH searches for a specified item in a range of cells and then returns the relative position of that item in the range.This is an upgraded version of the function MATCH
Syntax:
=Xmatch(lookup_value,range to look from)
Lookup_value: is the value you are looking for in the range, can be a number, text, or logical value, or a reference to one of these.
Range too look from: is a contiguous range of cells containing possible lookup values, a list of values, or a reference to a range.For example, I would like to find the location of part number 123.22