MATCH()

Description

Returns the relative position of an item in a range that matches a specified value.

How To Use in Sheets

MATCH(search_key, range, [search_type])

External Links

MATCH

Google Docs Help

11Better Sheets Tutorials

Creating A Dark Mode Theme | Announcing Dark Habits
IntermediateMost Popular
Build a habit tracker in dark mode. Learn how to use emojis and checkboxes effectively.

2

FREE

Use Index Match when you want Vlookup
Intermediate
Better Domain Portfolio Template
Intermediate

4

FREE

Secure Your Sheets by BetterSheets.co
Beginner
Add Pics to Marketplace in a Google Sheet
Beginner
How To Create An AutoFill in Google Sheets
Beginner
Wallace Asks: How To Find New Names
Got a list of names, need to add new ones to main list.

8

FREE

How To Select an Image based on Text in a Dropdown Menu
David Asks: About Primary Keys
Intermediate
Create relational databases with index/match
Zakir Asks: Find First Car in a Row
Beginner
Find the first value in a row.
Announcing Sell Daily and How I Built Sell Daily
Beginner