Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Google Sheets Match | Match Function Google Sheets | How to Use Match Google Sheets. That video is uploaded by Software Spring at 2019-10-09T22:25:02-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [UvgI6P4Mhm8]
| Name | Google Sheets Match | Match Function Google Sheets | How to Use Match Google Sheets |
| Video Uploader | Video From Software Spring |
| Upload Date | This Video Uploaded At 10-10-2019 05:25:02 |
| Video Discription | 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. UvgI6P4Mhm8 |
| Category | Education |
| Tags | google sheets match | match function google sheets | google sheet match | how to use match google sheets | google sheets tutorial | tutorial | match | example | function | google sheets functions | google sheets | google spreadsheet | get | position | extract | retrieve | data | row | column | excel | alternative | free | steps | video |
