---
title: "VLOOKUP function in Excel"  
description: "VLOOKUP function in Excel"  
author: "AVADHESH PATEL"  
published: 2013-03-30  
updated: 2019-09-07  
canonical: https://www.mindstick.com/articles/1179/vlookup-function-in-excel  
category: "excel"  
tags: ["excel"]  
reading_time: 2 minutes  

---

# VLOOKUP function in Excel

The VLOOKUP function will automatically find the value you need from any list. In this article you'll see how to use the VLOOKUP function and how to easily avoid the mistakes that most people make when it comes to using the VLOOKUP function in a formula. Steps are given below.\

##### Formula:

VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])

Step 1: First create two sheet “Price List” and “Sales Order” as below

![VLOOKUP function in Excel](https://www.mindstick.com/mindstickarticle/25272d8c-990a-4ab0-9790-f64544a1225a/images/0eb043c3-ba82-49e7-917a-5114f9109e57.png)

![VLOOKUP function in Excel](https://www.mindstick.com/mindstickarticle/25272d8c-990a-4ab0-9790-f64544a1225a/images/cf1aa803-516b-4d12-bad0-d4c366fa6a20.png)

Step 2: Now select cell on “Sales Order” where we apply VLOOKUP formula and give lookup_value index as below image

![VLOOKUP function in Excel](https://www.mindstick.com/mindstickarticle/25272d8c-990a-4ab0-9790-f64544a1225a/images/51ecdc77-af0f-4780-b202-4692ade91713.png)

Now give the table_array value as below image

![VLOOKUP function in Excel](https://www.mindstick.com/mindstickarticle/25272d8c-990a-4ab0-9790-f64544a1225a/images/84deb378-2426-4737-9768-b28ba5cbf18c.png)

Put the comma after table_array parameter and give the col_index_num. Here col_index_num is 2, and set [range_lookup] as false. Hence whole formula is

## =VLOOKUP (C9,'Price List'!C9:E16,2,FALSE)

Now press enter button and see output

![VLOOKUP function in Excel](https://www.mindstick.com/mindstickarticle/25272d8c-990a-4ab0-9790-f64544a1225a/images/b4e68cd4-ad5d-4b41-ada6-4b6388c3c370.png)

Step 3: Now apply all cell of column “Item Name”.

Step 4: Apply same process for display “Unit Price” as below image, formula for unit price as following

## =VLOOKUP (C9,'Price List'!C9:E16,3,FALSE)

![VLOOKUP function in Excel](https://www.mindstick.com/mindstickarticle/25272d8c-990a-4ab0-9790-f64544a1225a/images/6dd4a8e0-6f73-46cf-a361-c297fe2438d3.png)

Step 5: Now you can calculate “Total” amount and percentage and whole output screen as below. Get the help for calculating sum, product and percentage from following link.

http://www.mindstick.com/Articles/e790a001-fcca-4077-bdbe-66da92bcc5fb/?Sum%20Function%20in%20Excel

http://www.mindstick.com/Articles/2820228e-d10a-438e-808d-00879cce50a3/?How%20to%20do%20percentages%20in%20Excel

![VLOOKUP function in Excel](https://www.mindstick.com/mindstickarticle/25272d8c-990a-4ab0-9790-f64544a1225a/images/5802697d-ea2c-4adb-9cd7-48d2413e1525.png)

---

Original Source: https://www.mindstick.com/articles/1179/vlookup-function-in-excel

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.