Category: Excel

A Simple Excel VLOOKUP example

Posted on by DevPaulC
In this example, I will show you a simple way to use VLOOKUP that even a beginner would understand. VLOOKUP represents Vertical Lookup. That means Excel will look for a value on the vertical, from top to bottom, and return the corresponding value from the same row where the value is found. Simple Enough? Let's see it in action In the table below in cell B2, I'm looking to write a VLOOKUP formula to get the color of the fruit Banana. As you can see, I have a reference table with fruit colors. Banana is in the table and...read more

How to use VLOOKUP in Excel

Posted on by DevPaulC
Excel Vlookup is the most powerful formula in Excel. Also vlookup is one of the formulas that are least used because so many users are scared of it. In this tutorial you will learn: how to use vlookup in Excel what is the vlookup syntax how to do a vlookup between two spreadsheets why is my vlookup not working why is xlookup coming and how will it improve vlookup If you know vlookup and pivot tables you will find the most value out of Excel. How to use vlookup in Excel We'll continue with our example of the Grocery...read more

How to Calculate BMI in Excel

Posted on by DevPaulC
The BMI calculation formula is =weight(kg)/height(m)^2. In this example, we'll apply this formula in Excel. The formula works for the metric measurements. If you have your measurements for height and weight in imperial units, you'll first have to convert them to metric. Step 1: Calculate BMI in Excel in the metric system. The weight is listed in cell A2, the height is listed in cell B2 and the BMI is calculated in cell C2. The calculation here is =A2/(B2*B2). Make sure you isolate the (B2*B2) to ensure the order of operations. Another way to write the formula would be...read more