Excel Formulas to Find the Partial Match with VLOOKUP Function!!
Tags: excelformula, excelformulas
Published: 2021-01-27 11:41:40

---
title: Excel Formulas to Find the Partial Match with VLOOKUP Function!!
published: true
date: 2021-01-27 11:38:52 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-find-partial-match-with-vlookup/
---

In Excel, the [**VLOOKUP function**](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/) is very strong, and we often use this function in our daily life. Here we will show how to **find the partial match with the VLOOKUP function**. 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)

[![Partial match with VLOOKUP](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Partial-match-with-VLOOKUP.png)](https://geekexcel.com/excel-formulas-find-partial-match-with-vlookup/partial-match-with-vlookup/#main)<figcaption id="caption-attachment-21443">Partial match with VLOOKUP</figcaption>

## General Formula:

- You can use the below formula to get the partial matching.

**=[VLOOKUP](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)(value&”\*”,data,column,[FALSE](https://geekexcel.com/use-false-function-in-microsoft-excel-365-simple-methods/))**

## Syntax Explanations:

- **VLOOKUP** – This function will help to lookup data in a range or table by row. Read more on the **[VLOOKUP function](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)**.
- **FALSE** – In Excel, the **[FALSE function](https://geekexcel.com/use-false-function-in-microsoft-excel-365-simple-methods/)** returns the logical value FALSE.
- **Asterisk (\*)** – This wildcard will represent any number of characters.
- **Value** – It is the criteria that want to be found.
- **Data** – It represents the input data from your worksheet.
- **Column** – It represents the column number.
- **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:

For instance, You have data like the below table where you have student’s full names in one column and their marks and grade in another column. And from this data, you want to look up a particular student’s marks but only with the first name. Let’s see how to find it.

- First, we will enter the input data in **Column**  **B** , **Column C** , and **Column D**.

![Input Ranges](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Input-Ranges-19.png)<figcaption id="caption-attachment-21439">Input Ranges</figcaption>

- Then apply the above-given formula to the **Cell G4** and press **ENTER** key.

![Enter the formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Enter-the-formula-24.png)<figcaption id="caption-attachment-21440">Enter the formula</figcaption>

- It will return the result as shown below.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Result-45.png)<figcaption id="caption-attachment-21441">Result</figcaption>

## Bottom-Line:

In this tutorial, we have described the simple and useful steps to **find the partial match in Excel by using the VLOOKUP function**. Hope you understand. If you have any **questions,** leave them in the below **comment** box. We will assist you. Thank you so much for visiting our site **[Geek Excel](https://geekexcel.com/)** To learn more formulas about Excel, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Ahead:

- **[Excel Formulas: Multiple Chained VLOOKUPs ~ Simple Guide!!](https://geekexcel.com/excel-formulas-multiple-chained-vlookups/)**
- **[Excel Formulas to Find the Partial Match Against the Number!!](https://geekexcel.com/excel-formulas-find-partial-match-against-the-number/)**