Excel Formulas to Lookup the Cost for the Product or Service!!
Tags: excelformula, excelformulas
Published: 2021-01-18 04:03:41

---
title: Excel Formulas to Lookup the Cost for the Product or Service!!
published: true
date: 2021-01-17 10:52:30 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-lookup-the-cost-for-the-product-or-service/
---

If you have a list of products or services (or related options), with associated costs, and you need to find and retrieve the cost for a specific option.  What would you do? In this case, you can use the [**VLOOKUP Function**](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/) to get them in a quick way. Let’s see the formula to **lookup the cost for the specified product or service in Excel**. 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)
## General Formula:

- Use the below formula to get the cost of the product.

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

## Syntax Explanations:

- **VLOOKUP** – In Excel, it helps to look up data in a range or table by row. Read more on **[VLOOKUP Function](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)**.
- **FALSE** – The Excel **[FALSE function](https://geekexcel.com/use-false-function-in-microsoft-excel-365-simple-methods/) **returns the logical value FALSE.
- **Product** – It is the criteria which you need to get the cost.
- **Table** – It represents the input data from your worksheet.
- **Column\_num** – It represented the column number of the selected data where the cost is available.
- **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.

## Example:

Let’s see how to get the cost of a specified product or service from the given data.

- First, we will give the input values in **[Column](https://geekexcel.com/excel-office-365-columns/) B** and **Column C**.

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

- Then, enter the given formula in the [**formula**   **bar**](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/) section or **cellF3**.

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

- It will display the result in the selected [**cell**](https://geekexcel.com/excel-cells-options/).

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

## Bottom-Line:

Hope you understood how to **lookup the cost of the specified product in Excel**. If you have any **issue** regarding this article or any unresolved **query,** please comment in the **comment** box below. We will assist you. Thank you so much for reading. To learn more, check out **[Geek Excel](https://geekexcel.com/)!! **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Related Articles:

- **[Excel Formulas to Get the Employee Information with VLOOKUP Function](https://geekexcel.com/excel-formulas-get-employee-information-with-vlookup-function/)**
- **[Excel Formulas to Find the Closest Match ~ Simple Guide!!](https://geekexcel.com/excel-formulas-find-closest-match/)**