Excel Formulas to Find First Match between Two Ranges ~ Quick Tricks!!
Tags: excelformula, excelformulas
Published: 2021-07-13 03:22:06

---
title: Excel Formulas to Find First Match between Two Ranges ~ Quick Tricks!!
published: true
date: 2021-07-09 07:31:46 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-find-first-match-between-two-ranges/
---

Excel allows us to find the first match between two ranges with [**INDEX**](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)**, [MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/),** and [**COUNTIF**](https://geekexcel.com/formulas-to-count-with-countif-function-in-excel-office-365/)functions. This step-by-step tutorial will assist all levels of Excel users to learn how to **get the first match between two ranges in Excel**. Let’s get into this article!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![First match between two ranges](https://geekexcel.com/wp-content/uploads/2021/07/First-match-between-two-ranges.png)](https://geekexcel.com/excel-formulas-to-find-first-match-between-two-ranges/first-match-between-two-ranges/#main)<figcaption id="caption-attachment-48748">The first match between two ranges</figcaption>

## Generic Formula:

- Use the below formula to get the first matchable value from two arrays in Excel.

**=[INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)(range2,[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)([TRUE](https://geekexcel.com/use-true-function-in-microsoft-excel-365-simple-methods/),[COUNTIF](https://geekexcel.com/formulas-to-count-with-countif-function-in-excel-office-365/)(range1,range2)>0,0))**

## Syntax Explanations:

- **INDEX** – In Excel, the [**INDEX function**](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/) will return the value at a given position in a range or array.
- **MATCH** – The [**MATCH function**](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/) is used to locate the position of a lookup value in a row, column, or table.
- **TRUE** – The **[TRUE function](https://geekexcel.com/use-true-function-in-microsoft-excel-365-simple-methods/)** helps to returns the value TRUE if the given conditions will be TRUE or Vice Versa.
- **COUNTIF** – This function is used to count the number of cells that meet a single condition or criteria. Read more on the [**COUNTIF Function**](https://geekexcel.com/formulas-to-count-with-countif-function-in-excel-office-365/).
- **Range 1 & 2** – It represents the input ranges.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Practical Example:

Refer to the below example image.

- First, we will enter the input values in **Column B** , and **Column C**.
- Here we are going to find out the first matching value.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/07/Input-Ranges-34.png)<figcaption id="caption-attachment-48749">Input Ranges</figcaption>

- Select any cell and type the above-given formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/07/Enter-the-formula-33.png)<figcaption id="caption-attachment-48751">Enter the formula</figcaption>

- After that, Press **CTRL** + **SHIFT** + **ENTER**  Keys.
- Finally, you can get the result as shown below.

![Result](https://geekexcel.com/wp-content/uploads/2021/07/Result-34.png)<figcaption id="caption-attachment-48750">Result</figcaption>

## Verdict:

From this chapter, you can get some clarification on how to **find the first match between two ranges in Excel**. Let me know if you have any **doubts** regarding this article or any other Excel/VBA topic.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Ahead:

- **[Excel Formulas to Define Range Based on Cell Value ~ Quickly!!](https://geekexcel.com/excel-formulas-to-define-range-based-on-cell-value/)**
- **[How to Insert a Date or Formatted Date in Excel Office 365?](https://geekexcel.com/how-to-insert-a-date-or-formatted-date-in-excel-office-365/)**
- **[Excel Formulas to Test All Values in a Range are at least Certain Threshold](https://geekexcel.com/excel-formulas-test-all-values-in-a-range-are-at-least-certain-value/)**
- **[Excel Formulas to Get the Percentage Discount ~ Useful Tricks!!](https://geekexcel.com/excel-formulas-to-get-the-percentage-discount/)**