How to use VLOOKUP to Create a Search Box? ~ Complete Guide
Tags: excelpreface, createsearchboxwithv, excelbasics, exceltutorials
Published: 2021-02-10 08:02:45

---
title: How to use VLOOKUP to Create a Search Box? ~ Complete Guide
published: true
date: 2021-02-05 05:31:03 UTC
tags: ExcelPreface,CreatesearchboxwithV,ExcelBasics,ExcelTutorials
canonical_url: https://geekexcel.com/how-to-create-search-box-vlookup-function/
---

A Search box will allow you to quickly get the matching result when you have the identifier. This page will guide you to learn the steps to **create a search box in Excel 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)

## Steps to create a Search Box:

**Search Box** in Excel is a customized function that is used to search anything in a worksheet. Instead of using the formula, you can use the search box to get the result.

For instance, you have a student’s mark list, and you need to find the one student’s mark from the data. The below steps will help you to achieve this work.

- First, we will give the input values in **Column B** to **Column G**.

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

- Then, select the **cell J4** , where we need to display the result.

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

- Click the **“Formula”** tab from the  [**Ribbon**](https://geekexcel.com/ribbon-keyboard-shortcut-keys-in-microsoft-excel-365/).

![Select the formula tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Select-the-formula-tab.png)<figcaption id="caption-attachment-21676">Select the formula tab</figcaption>

- Here, we will select the **“Insert Function”** option.

![Insert Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Insert-Function.png)<figcaption id="caption-attachment-21677">Insert Function</figcaption>

- Search for **“VLOOKUP”** then select to **“Go”** option.

![Search Vlookup](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Search-Vlookup.png)<figcaption id="caption-attachment-21678">Search Vlookup</figcaption>

- The VLOOKUP function will appear in the below box and click on the **“OK”** button.

![Select Vlookup](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Select-Vlookup.png)<figcaption id="caption-attachment-21679">Select Vlookup</figcaption>

- Now, it will open the **“Function Arguments”** window. In the **1st box** , you need to enter the **lookup value** which you want to be found.

![Lookup Value](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Lookup-Value.png)<figcaption id="caption-attachment-21680">Lookup Value</figcaption>

- In the **2nd box,** we will select the data range from the worksheet.

![Table Array](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Table-Array.png)<figcaption id="caption-attachment-21681">Table Array</figcaption>

- The next box consists of **column numbers** , where the lookup value will available.

![Column Number](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Column-Number-2.png)<figcaption id="caption-attachment-21682">Column Number</figcaption>

- In the last box, type **“False”** to search the **exact matching value** **[True= Approximate match],** and click the **“Ok”** button.

![Click ok button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Click-ok-button.png)<figcaption id="caption-attachment-21683">Click ok button</figcaption>

- Now the result will display in the selected cell.

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

## Wind-Up:

From this guide, you can easily understand the simple steps used to **create the search box with the VLOOKUP function in Excel**. Let me know your thoughts in the below **comment** box. We will assist you!! To learn more about Excel, check out **[Geek Excel](https://geekexcel.com/)!!**

### Read Ahead:

- **[Excel Formulas to Find the Self-Contained VLOOKUP!!](https://geekexcel.com/excel-formulas-to-find-the-self-contained-vlookup/)**
- **[Excel Formulas to Find the Reverse VLOOKUP Value ~ Clear-Cut Example](https://geekexcel.com/excel-formulas-reverse-vlookup/)**