Google Sheets Match | Match Function Google Sheets | How to Use Match Google Sheets
The Google Sheets MATCH function returns the position of the search key in a one dimensional horizontal or vertical array or range. That is, it returns the position of the search key in the
array. However, the function doesn't extract the data. Nest the MATCH function inside another function, for example the INDEX function, to extract data from one or more cells, relative to the position returned by MATCH.
Here is the format of the MATCH function:
=MATCH(search_key, range, [search_type])
Here's an example of using Google Sheets MATCH function to get the position of data. Say cells B1 to E6 has names of computer components. Assume that you want to find out the position of the component "Hard Disk" in this range. Further assume you want an exact match.
Type the MATCH function Google Sheets, say in cell A2 as:
=MATCH("Hard Disk", B1:E6, 0)
Then, press Enter.
Assuming one of the cells in the range B1 to E6 has the data "Hard Disk", cell A2 should display a number. Suppose if it is 2, it means cell C1 has the said data.
If you want to extract the data "Hard Disk", then you have to use a function like INDEX, VLOOKUP, or HLOOKUP.
Please take a look at this Google Sheets tutorial, which explains the MATCH function with an example, and get to know how to use match Google Sheets to get a data position in a spreadsheet.