![[Featured Image] A person uses Google Sheets MATCH on their office computer.](https://images.ctfassets.net/wp1lcwdav1p1/3K7FnbMdu6gvddmPLNGW1d/a752f72f72cdb5f2d400f31fe5eb51a1/GettyImages-1353281811.jpg?w=330&h=216&q=60&fit=fill&f=faces&fm=jpg&fl=progressive)
How to Use Google Sheets MATCH
Read this article to learn what the Google Sheets MATCH function is and how to use it, how to troubleshoot it, and how it differs from VLOOKUP.
April 5, 2024
Article
Coursera Staff
Editorial Team
Bio
Coursera’s editorial team is comprised of highly experienced professional editors, writers, and fact-checkers. Our articles are deeply researched and thoroughly reviewed to ensure we are providing trustworthy information and advice for any topic. We understand that taking the next step in your education or career can raise questions. We are here to provide actionable, reliable, and relevant answers so you can achieve your goals.
![[Featured Image] A person sits in their kitchen and uses their laptop to research whether they should earn IT certifications or a degree for their career path.](https://images.ctfassets.net/wp1lcwdav1p1/4GiWMOsQJa6rvknjvVuYYL/f1f13e556695a5207b41b70ee768aeee/GettyImages-1961218042.jpg?w=330&h=216&q=60&fit=fill&f=faces&fm=jpg&fl=progressive)
![[Featured Image] A recent college graduate sits at a computer and prepares their resume to enter the tech job market as a data analyst.](https://images.ctfassets.net/wp1lcwdav1p1/2ca2QZHzx7WsIkuJ6I74G9/1659f68aec4902358ceea0f3d830b5f6/GettyImages-1215009025.jpg?w=330&h=216&q=60&fit=fill&f=faces&fm=jpg&fl=progressive)
![[Featured Image] A UX data analyst wears a headset, sits at a desk in their office, and uses a computer to look at data to determine whether their organization's product is user-friendly.](https://images.ctfassets.net/wp1lcwdav1p1/2jTvA7ctwAyNrnFFLXZ1Xa/6f6f306cd83cfd9afa2abb2823157b4e/GettyImages-1191627970.jpg?w=330&h=216&q=60&fit=fill&f=faces&fm=jpg&fl=progressive)
![[Featured Image] A machine learning professional sits at a laptop outside and uses random forest algorithms on a project.](https://images.ctfassets.net/wp1lcwdav1p1/3ZT5igrnMSiw9x7KUtq5Kt/22dcfca88f71498348f364e7934efb42/GettyImages-1444442656.jpg?w=330&h=216&q=60&fit=fill&f=faces&fm=jpg&fl=progressive)
![[Featured Image] A business intelligence developer sits at her desk and analyzes data on her computer screens generated by backpropagation neural networks.](https://images.ctfassets.net/wp1lcwdav1p1/5efI4dznrQHUNLpCoWpIJj/54729265abd2d452c82bc9ea9c57749f/GettyImages-1435081388-converted-from-jpg.webp?w=330&h=216&q=60&fit=fill&f=faces&fm=jpg&fl=progressive)