VLOOKUP formula in Excel, explanation with the simple example

VLOOKUP is an exceptionally impressive tool in Excel which allows you to locate values in a table or range by row. It is very advantageous when you need to work on a huge chunk of data and find things from the other sheets or workbooks.

Here is the formula =VLOOKUP (What is the source reference value, from where you want to reference it with and pick the desired data, Column range for the desired value, Add 0(False) if you need exact outcome or add 1(True) if you need approximate value).

You need to keep a few things in mind before I will explain it through an example. The reference value is also called the Lookup Value, and It should always be in the first column in the lookup range to work this formula without an error.

Sample1.

Now take the example of the below table. Suppose we have two sheets (Sheet1 & Sheet2)

Sheet 1

Sheet 2

As per the above Image, we have huge data in sheet1 with multiple data fields, and sheet2 only has a name. Now we want to capture other details with the Names available in sheet2.

Formula: =Vlookup(A2, Sheet1!A:F,range,0)

Formula with Lookup values

Referring to the above image, we have got the expected value from sheet1 to the sheet 2 for the values which are available in sheet1 and for the ones which are not available in sheet1 it shows N/A.

We can pursue the same formula to fetch other data for these people from sheet1.Sample2

Comments

Beauty Insides- Temu- DNM Matte Long Lasting Canster Lipstick- Reviews

When it comes to enhancing our lips, the possibilities are seemingly limitless: lipstick, lip gloss, lip stain. However, in the realm of cosmetics, often the little things have the biggest effects. Now for the little capsules lip colors on Temu—the unsung heroes of the cosmetics industry. What exactly is so great about these tiny lip colors, you ask? Let's explore the wonders of these small yet powerful devices that can drastically alter your appearance. A Shade for Every Mood There are eighteen different colors in a single packet, which makes them handy in a variety of occasions. These are an extensive range of tints and finishes available in little lip colors to suit any mood or occasion. There's a tiny lip color out there waiting to match your style and express your mood, whether you want a sheer, glossy, or matte appearance. Its you who will decide how want to carry one. Affordable Luxury When comparing the pricing of these small lip colors to their full-sized equivalents, ...

Unveiling the Future: Exciting New Discoveries in the Realm of Information Technology

Information Technology (IT) continues to reshape our world at an astonishing pace, and recent advancements have unveiled groundbreaking discoveries that promise to revolutionize our digital landscape. From cutting-edge hardware innovations to groundbreaking software breakthroughs, the realm of IT is witnessing an era of unprecedented progress. In this article, we will explore some of the most intriguing new discoveries that are reshaping the way we interact with technology and opening up new possibilities for the future. Quantum Computing: A Paradigm Shift Quantum computing, long regarded as the holy grail of computational power, has made remarkable strides in recent years. Researchers have made significant breakthroughs in overcoming the limitations of qubits, the fundamental units of quantum information. These advancements have led to the development of more stable and scalable quantum systems, making quantum computing a tangible reality. With their unparalleled processing power, qua...

These are the top 5 factors to consider before purchasing a new phone.

New generation phones are being used for a variety of purposes, including communication, entertainment, work, education, and more. Smartphones can be used for making calls and sending texts, surfing the web, streaming music and videos, playing games, managing finances, tracking fitness goals, and much more. Additionally, many newer phones are equipped with artificial intelligence (AI) capabilities, which allow users to access a variety of AI-powered applications and services. 1. Cost is an important factor when buying a new phone. You should consider your budget and decide how much you can spend on a phone. 2. Operating System: Most phones run on either Android or iOS, so you should decide which operating system you prefer before making a purchase. 3. Battery life: Battery life is important when it comes to smartphones, as you don't want to be constantly searching for a place to plug in your device. Look for phones that have long-lasting batteries and good power management feature...

Influence Professionals

Search This Blog