Excel Formulas to Calculate the Shipping Cost with VLOOKUP Function!!
Tags: excelformula, excelformulas
Published: 2020-12-18 10:16:46

---
title: Excel Formulas to Calculate the Shipping Cost with VLOOKUP Function!!
published: true
date: 2020-12-18 10:09:11 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-shipping-cost-with-vlookup/
---

If you are in the import-export business then you know that shipping cost calculations are an important part of the business.  And most of the time you have different shipping costs for different ranges of weights. The **VLOOKUP function** can be used to calculate the shipping cost based on the specified weight of an item.

Here, we will show the simple formula used to **calculate the shipping cost in Excel**. Let’s see them below!! 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)

[![Formulas to calculate shipping cost](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Formulas-to-calculate-shipping-cost.png)](https://geekexcel.com/excel-formulas-shipping-cost-with-vlookup/formulas-to-calculate-shipping-cost/#main)<figcaption id="caption-attachment-19958">Formulas to calculate shipping cost</figcaption>
## Generic Formula:

- To calculate the shipping cost, you can use the below formula.

**=[VLOOKUP](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)(weight,table,column,1)\*weight**

## Syntax Explanations:

- **VLOOKUP** – It helps to look up 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/)**.
- **Weight** – It represents the weight per kg that you want to calculate the cost in your worksheet.
- **Table** – It is the input values in the worksheet.
- **Column** – It returns 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.
- **Multiplication (\*)** – In this symbol will multiply any two values or numbers.

## Example:

- Let’s see the below example image to calculate the shipping cost.
- First, we will create a table with weight and cost in **Column B** and **Column C**.
- Then, enter the given formula in the formula bar section.
- After applying the formula, it will display the result in the selected **cell F4**.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Example-64.png)<figcaption id="caption-attachment-19956">Example</figcaption>

## Wrap-Up:

Hope you understood the simple formula used to **calculate the shipping cost in Excel using the VLOOKUP Function**. Please state your **query** in the below  **comment** box. We will assist you. To learn more, check out our website **[Geek Excel](https://geekexcel.com/)** and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Ahead:

- **[How to Find Vlookup Value Between Two Numbers in Excel?](https://geekexcel.com/how-to-find-vlookup-value-between-two-numbers-in-excel/)**
- [**Excel Formulas to Sum the Values from Every Nth Column!!**](https://geekexcel.com/excel-formulas-to-sum-the-values-from-every-nth-column/)