- The VLOOKUP function in Excel finds things in a table or range by row. The secret is to organize your data so that the value you look up is to the left of the value you want to find. Then use VLOOKUP to find the value
- VLOOKUP is an Excel function to look up data in a table organized vertically. VLOOKUP supports approximate and exact matching, and wildcards (* ?) for partial matches. Lookup values must appear in the first column of the table passed into VLOOKUP
- Multiple Lookup Tables. When using the VLOOKUP function in Excel, you can have multiple lookup tables. You can use the IF function to check whether a condition is met, and return one lookup table if TRUE and another lookup table if FALSE.. 1. Create two named ranges: Table1 and Table2.. 2. Select cell E4 and enter the VLOOKUP function shown below
- e whether we need to order more of the item in Column A. We use the IF function so that if the value in position 2 in Sheet4!A2:B5 is greater than 10 , we write No to indicate that we don't need to order more
- The Last Guide to VLOOKUP in Excel You'll Ever Need. Written by Kasper Langmann, Microsoft Office Specialist. Updated September 7, 2020. VLOOKUP is one of the most well-known Excel functions - and not without reason! VLOOKUP's ability to looking up data is unparalleled in Excel.

- VLOOKUP is an Excel function. This article will assume that the reader already has a passing understanding of Excel functions, and can use basic functions such as SUM, AVERAGE, and TODAY. In its most common usage, VLOOKUP is a database function, meaning that it works with database tables - or more simply, lists of things in an Excel worksheet
- Her er en rask veiledning for de som trenger hjelp til å bruke VLOOKUP - funksjonen i Excel. VLOOKUP er en svært nyttig funksjon for enkelt å søke gjennom én eller flere kolonner i store regneark for å finne relaterte data. Du kan bruke HLOOKUP til å gjøre det samme for ett eller flere rader med data. I utgangspunktet når du bruker VLOOKUP, du spør Her er en verdi, finne verdien.
- Beskrivelse. Du kan bruke FINN.RAD til å søke etter den første kolonnen i et område (område: To eller flere celler i et regneark. Cellene i området kan være tilstøtende eller atskilte.) med celler, og deretter returnere en verdi fra en hvilken som helst celle i samme rad i området. Anta for eksempel at du har en liste over ansatte i området A2:C10
- A VLookup is used in a spreadsheet to find records within a data spreadsheet. A VLookup is extremely useful when a large amount of data needs to be searched to find a particular piece of information
- MS Excel inneholder flere funksjoner du kanskje ikke har sett, eller som har gått i glemmeboken. I volum 1 av Excel-guiden tar vi for oss 6 tidssparende «hacks». Vi gjennomgår blant annet Excel-funksjonene «VLOOKUP», nedtrekkbare menyer, transformering av data og formler
- cm.com/excel-vlookup-software-tutorial/ This video shows you how to use MicroSoft Excel's VLOOKUP function to compare values in two lists. It a..
- Excel Formula Training. Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges

How to Use Vlookup With an Excel Spreadsheet. This wikiHow teaches you how to find a cell's corresponding information in Microsoft Excel using the VLOOKUP formula. The VLOOKUP formula is useful for finding things like employee salary.. * Learn VLOOKUP the easy way with screenshots, examples, detailed break down of exactly how the formula works in Excel*. Function =VLOOKUP(lookup value, table range, column number). For example, look for this piece of information, in the following area, and give me some corresponding data in another column VLOOKUP works a lot like a phone book, where you start with the piece of data you know, like someone's name, in order to find out what you don't know, like their phone number. So, as an example, I'll enter part numbers, the thing I know, and find out Prices, the thing I don't know

The vlookup is the most useful, yet most mis-understood function in Excel. Learning how to vlookup in Excel 2007/2010/2013/2016 and the Excel version in Office 365 can be very useful. This is a step by step vlookup tutorial (only 7 steps) suitable for beginners. It's the quickest and simplest way to do a vlookup Whilst VLOOKUP and IF functions are useful on their own, together they deliver even more valuable experiences. Today, we will be looking at a few simple examples that will show you how to Vlookup with If condition in Excel * The Excel VLOOKUP Function is listed under Microsoft Excel's Lookup Functions category*. It lookups for a value in the first column of a table and returns the value from the same row of the matched value using the index number. In simple words, it performs a vertical lookup In this video I explain everything you need to know to get started with VLOOKUP for Excel. Download the Excel file: https:.

ExcelのVLOOKUP関数の使い方!指定列からデータを取り出す方法を初心者向けにサンプルでわかりやすく解説. Excelの「VLOOKUP関数」は、検索したデータに該当した行の指定列からデータを取り出す関数です。今回はその基本的な使い方を解説します This Excel tutorial explains how to use the Excel VLOOKUP function with syntax and examples. The VLOOKUP function performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position VLOOKUP Function - Introduction. VLOOKUP function is THE benchmark. You know something in Excel if you know how to use the VLOOKUP function. If you don't, you better not list Excel as one of your strong areas in your resume VLOOKUP is a powerful function in Excel. In this tutorial, I'll show you how to use VLOOKUP in Excel 2016. Specifically, I'll review an example with the steps needed to apply a VLOOKUP. But before we begin, let's first review the elements of the VLOOKUP function. Elements of the VLOOKUP in Excel 201 Vlookup (V stands for 'Vertical') is an in-built function in excel which allows establishing a relationship between different columns of excel. In other words, it allows you to find (look up) a value from one column of data and returns it's respective or corresponding value from another column. In this VLOOKUP guide, we will learn . Usage of.

To the novice Excel user, however, setting up VLOOKUP can look like an intimidating process -- but it needn't be. Just follow our step-by-step tutorial on how to use VLOOKUP in Excel today. How to. Otherwise, **VLOOKUP** will not retrieve the correct data. Note: If you omit the match_type argument **Excel** will use approximate match by default, but will retrieve the exact match if one exists. If you need **VLOOKUP** help or if you have additional questions on how to use **VLOOKUP** please let me know by posting a comment

- Excel has a number of built-in formulas and functions to help you store, search and analyze your data. If you are working with large worksheets, then finding specific data within that worksheet can prove quite difficult. This tutorial will show you how to use the Vlookup function to find data quickly and easily. We will [
- VLOOKUP - Pembahasan kali ini materi yang akan dibahas rumus.co.id adalah mengenai Rumus, Fungsi, Contoh dan Cara Menggunakannya Vlookup pada excel, Yuk belajar Vlookup sekarang! Fungsi vlookup atau Rumus vlookup merupakan salah satu fungsi atau rumus excel dasar yang sering sekali digunakan. Rumus Excel ini yang termasuk pada kategori lookup dan reference ini akan sering kamu butuhkan.
- Otherwise, VLOOKUP will not retrieve the correct data. Note: If you omit the match_type argument Excel will use approximate match by default, but will retrieve the exact match if one exists. If you need VLOOKUP help or if you have additional questions on how to use VLOOKUP please let me know by posting a comment

Excel VLOOKUP Tutorial. In this Excel VLOOKUP tutorial, we discuss what is the VLOOKUP Function in Excel, how it works along with practical examples. The VLOOKUP (vertical lookup) function in Excel looks up a piece of information or value from one column of a table or dataset and extracts and returns some corresponding value or information from. * VLOOKUP is an Excel function that allows you to search and retrieve a cell's content from one column and use it in another location to retrieve data*. As you might guess, the V stands for vertical and relies on looking up data from the leftmost column of a lookup table The Excel VLOOKUP function searches for a value by matching on the first column of a table and returns the corresponding value from a certain column in the same row. This tutorial is talking about how to use the VLOOKUP function by explaining the syntax , arguments , return value , function notes and simple examples in details VLOOKUP is one of the most powerful and top used functions in Excel. Using IF logical function with VLOOKUP makes the formulas more powerful. In this article, we shall see a good number of examples where we have paired VLOOKUP with IF condition in Excel Vlookup (short for 'vertical' lookup) is a built-in Excel function that is designed to work with data that is organised into columns. For a specified value, the function finds (or 'looks up') the value in one column of data, and returns the corresponding value from another column

How To Use VLOOKUP in Excel - 6 7. Now we will create the VLOOKUP formula that will translate the A Pcode in cell C2 to the description found from the Party Codes worksheet. Note: VLOOKUP relies on 4 function arguments which are numbered above. The last item, Range_lookup [4] is optional and can be blank excel vba, makro date, dato, finn.rad, proper, stor.forbokstav, tekst, text, vlookup Finn.Rad - Når vi vil kombinere informasjon fra flere ark by Ketil Melhus on august 8, 2013 with Ingen kommentare The english function name VLOOKUP() has been translated into 19 languages. For all other languages, the english function name is used. There are some differences between the translations in different versions of Excel One more way to Vlookup between multiple sheets in Excel is to use a combination of VLOOKUP and INDIRECT functions. This method requires a little preparation, but in the end, you will have a more compact formula to Vlookup in any number of spreadsheets. A generic formula to Vlookup across sheets is as follows

Introduction to VLOOKUP Function in Excel. Vlookup function is used to lookup the value with a reference cell and fetch the value from the selected lookup table array and is quite useful and one of the most widely used excel functions We can use a table or single column to lookup the value How to Use VLOOKUP in Excel: Walk Through Use the tabs Ingredient Orders and Supplier List for this Excel VLOOKUP example. Let's say that we manage a restaurant and are placing our weekly orders to suppliers. The chefs have given us a list of ingredients to order, and we need to insert information about the supplier

- VLOOKUP helps you look up a corresponding value for a cell from within your existing database. It works like any other function or formula in Excel, like SUM or AVERAGE. The VLOOKUP formula relies on four different arguments to present a filtered result; that is, you give it four inputs, and it gives you one output
- VLOOKUP (Vertical Lookup) is one among the lookup and reference functions in Excel that could help you to find particular information in your excel sheet. The simplest example that can be cited is a telephone directory where you use the person's name to lookup their telephone number
- Microsoft Excel has a vast variety of functions that can help users deal with different calculations and other tasks. VLOOKUP is a very useful function that can retrieve information that corresponds to a certain value from a database table. If you're new to Excel, you may experience difficulties with this function because it has four arguments
- The VLOOKUP function in Excel looks for a certain entry in the first column of a vertically oriented table. After it finds the row with the first match, it finds the column you specify in the function. The function then returns the cell contents of that row and column from the searched table
- Excel's vLookup formula pulls data from one spreadsheet into another by matching on a unique identifier located in both spreadsheets. For example, we want to add a column for email address but that data exists on a separate spreadsheet. vLookup can pull email addresses from Spreadsheet 2 into Spreadsheet 1 by matching CampusID 555123123 in both spreadsheets
- In VLOOKUP, col_index_no is a static value which is the reason VLOOKUP doesn't work like a dynamic function. If you are working on multiple column data, it's a pain to change its reference because you have to do this manually. The best way to solve this problem is to use MATCH Function in VLOOKUP for col_index_number
- Using VLOOKUP with CONCATENATE Method. If you are trying to return a text string rather than a number, or are using a version of Excel that doesn't have SUMIFS, then you are probably stuck with using a traditional lookup function such as VLOOKUP along with the CONCATENATE function to generate a single unique lookup column

- Excel Tables are just amazing and should be used all the time, whether you have 2 rows or 200,000 rows of data! You can read the benefits of using an Excel Table here: Excel Tables. When you use a Vlookup formula to lookup in an Excel Table then your formula becomes dynamic due to its structured referencing
- Many of our learners have told us they want to learn how to use Excel's VLOOKUP function. VLOOKUP is an extremely useful tool, and learning how to use it is easier than you think! Before you start, you should understand the basics of functions
- This Excel tutorial explains how to use the Excel LOOKUP function with syntax and examples. The Microsoft Excel LOOKUP function returns a value from a range (one row or one column) or from an array. There are 2 different syntaxes for the LOOKUP function
- In this VBA Tutorial, you learn how to use the VLookup function within your macros. This VBA VLookup Tutorial is accompanied by an Excel workbook containing the data and macros I use in the examples below. You can get immediate free access to this example workbook by clicking the button below
- Excel VLOOKUP is one of the most useful and important functions in Excel. The alphabet 'V' in VLookUp stands for Vertical. Read about Excel VLOOKUP here

** Hope you understood IF, ISNA and VLOOKUP function in Excel 2016, 2013 and 2010**. There are more articles on VLOOKUP Examples and HLOOKUP Examples here. Please do check more links here and if you have any unresolved query, please state that in the comment box below. We will help you. Below are the examples to learn more: In default, VLOOKUP function can return multiple corresponding values in the vertical level in Excel, in some cases, you may want to return multiple values in horizontal level as below screenshot shown. Here I will tell you a formula can solve this task. VLOOKUP and return multiple values horizontall VLOOKUP is one of Excel's most popular functions, especially among accountants. However, it is also plagued with issues. Microsoft has finally created VLOOKUP's replacement, XLOOKUP, which removes the limitations and adds extra functionality WorksheetFunction.VLookup method (Excel) 05/25/2019; 2 minutes to read; In this article. Searches for a value in the first column of a table array and returns a value in the same row from another column in the table array

On that basis, let me define the VLOOKUP function: As the name suggests, the VLOOKUP in Excel is used to look up or find a value in a table. The Wheat is called lookup_value. You may use the text, number, a cell reference etc as lookup_value. The lookup_value must be in the first column of the table-array excel一直都是一個方便又好用的工具，但我們常常被公式搞得一頭霧水，反而失去了它原本的實用性。今日要給大家vlookup教學，一個在excel中相當受歡迎的搜尋方法，會先帶大家認識什麼是vlookup？再帶大家實際操作一次，以及在使用時最常失敗的原因，趕快往下看教學吧 This post was inspired by the video series, 4 Essential Microsoft **Excel** Skills Every Marketer Should Learn. If you want to become a master of the almighty spreadsheet, watch the full video series here. I know, **VLOOKUP** function sounds like the geekiest, most complicated thing ever

Guide to VLOOKUP Table Array. Here we have discussed how to use the Table Array in Excel along with examples and downloadable Excel Template The Excel Vlookup function is one of Excel's most popular functions. However, although it is straightforward once you get to grips with it, many users initially have problems with this function. Therefore, in addition to this page, which provides an overview of the Vlookup function, we also have produced a more in-depth Excel Vlookup Tutorial 1. Get the VLOOKUP sample workbook (Excel 2007 and later). The zipped file is in xlsx format, and does not contain any macros. 2. For Excel 2003, get this version of the VLOOKUP sample file. The zipped file is in xls format, and does not contain any macros. 3

* In my earlier post, I had written about VLOOKUP in Excel*. It was a massive post of around 2500 words, it explains most of the things about the vertical lookup function in excel. Today's post is an extension to that post and here we will understand how to apply a VLOOKUP in VBA Excelの関数の中でもよく利用されるVLOOKUP関数。初心者の方でもわかりやすいように引数を1つずつ図解で解説しています。また実際の例を使用してどのようにVLOOKUP関数を使うのか基本的な使い方もご紹介します

VLOOKUP Google Sheets . Using VLOOKUP in Google Sheets is very similar to Excel. Unlike Excel, you have to press F1 to show the formula help screen. =VLOOKUP(search_key, range, index, [is_sorted]) ARGUMENTS: search_key - Value from first column of a table. range- The table from which to obtain a value. We must define this tabl La función VLOOKUP en Excel forma parte de las funciones de búsqueda de la hoja de cálculo y nos permite encontrar un valor dentro de un rango de celdas. La búsqueda realizada por esta función se hace sobre valores ubicados en una columna por lo que también se le conoce como una búsqueda vertical y es la razón por la que el nombre de la función inicia con una letra V Learn the most popular Excel Formulas ever: VLOOKUP, IF, SUMIF, INDEX/MATCH, COUNT, SUMPRODUCT plus more. 101 Ready To Use Excel Macros E-Book. Access 101 Ready To Use Macros with VBA code which you can Copy & Paste to your workbooks straight away This post explores Excel's lookup functions, approximate matches, fuzzy lookups, and exact matches. The built-in Excel lookup functions, such as VLOOKUP, are amazing. When implemented in the right way for special projects or in recurring use workbooks, they are able to save a ton of time. The VLOOKUP function alone has saved countless hours i

The VLOOKUP function is an immensely powerful and very useful function in Excel 2007 and Excel 2010. In today's hub We have looked at how the TRUE value looks at your reference data in your workbook and returns either the exact result, or an approximation ** Excel's VLOOKUP function is a basic but powerful feature available for you to make the most of the data in your spreadsheets**. For new users, VLOOKUP may seem like a mystical, complicated affair, but when you break it down, it becomes a simple ally for getting your data into the right places, whether you are pulling it from other workbooks, worksheets, or just across the page

Hope you understood how to use the VLOOKUP function in Excel. You can perform these function in Excel 2016, 2013 and 2010. There are more articles on VLOOKUP and HLOOKUP. Please do check more links here and if you have any unresolved query, please state that in the comment box below. We will help you. Popular Articles. The VLOOKUP Function in Excel Excel VBA is an acronym for Visual Basic for Applications and the VBA turns Excel from an ordinary spreadsheet into a fully-fledged application development environment. This tutorial will show you how to access VBA in Excel and how to use the Vlookup formula in VBA. To learn to harness the power of Excel, enroll in Excel 2013 The Basics now How to combine Excel VLOOKUP() and PivotTable for simple solutions by Susan Harkins in Software on April 30, 2019, 10:11 AM PST Combining features often extends the flexibility and efficiency of. VLOOKUP stands for Vertical Lookup. Learning vlookup is very easy but let's first understand how VLOOKUP works? Even dummies can easily do VLOOKUP in Excel. In plain English VLOOKUP is: - Go down until you find X in the first column;-When you find X, then go right Y columns - Tell me the value. Here is a VLOOKUP Example in Excel WorksheetFunction. VLOOKUP-Methode (Excel) WorksheetFunction.VLookup method (Excel) 05/25/2019; 2 Minuten Lesedauer; In diesem Artikel. Sucht in der ersten Spalte einer Tabellenmatrix nach einem Wert und gibt in der gleichen Zeile einen Wert aus einer anderen Spalte in der Tabellenmatrix zurück

- With Excel, there are always many different ways to solve a problem. Part of our job as analysts is to try and find the fastest and most efficient way to produce a result. Will we always get this right the first time? Absolutely not. Part of the fun is continuing to iterate, learn, and improve. VLOOKUP and INDEX MATCH can both produce the same.
- What is VLOOKUP in Excel? VLOOKUP stands for Vertical Lookup. As the name specifies, VLOOKUP is a built-in Excel function that helps you look for a specified value by searching for it vertically across the sheet. VLOOKUP in Excel may sound complicated, but you will find out that it is a very easy and useful tool once you try it. Look at the.
- The VLOOKUP function in Microsoft Excel is a great way to find relational data.. For example, you have a busy worksheet with a lot of data points, and you want to know the name of a supplier and.
- This Tutorial demonstrates how to use the Excel VLOOKUP Function in Excel to look up a value. VLOOKUP Function Overview. The VLOOKUP Function Vlookup stands for vertical lookup. It searches for a value in the leftmost column of a table. Then returns a value a specified number of columns to the right from the found value

Excel VLOOKUP function helps pull value from a table with the help of a matching ID or unique identifier. In the Example given below, we need to find asset description of three IDs in Table 2. Table 1 has the details of ID wise asset description The VLOOKUP function is available in Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel 2011 for Mac. Syntax. The syntax of the VLOOKUP function is as below: = VLOOKUP (lookup_value, table_array, column_index_num,[range_lookup]) Where the VLOOKUP function arguments are: Lookup_value-This is a required argument We can find values (numbers or text) that are associated with particular dates in excel by using the VLOOKUP function.We can do this by following the easy steps below. Figure 1: The Result of the Lookup Date. Setting up the Data. We need to have a table to make use of the VLOOKUP function. This table will contain the Dates in Column A and the Amounts (this could be text) in Column B

You can take help of VLookup and Choose function to get the correct result. How to use Reverse VLookup in Excel with VLookup Function. You must have to take given simple steps to reverse VLookup in Excel using VLookup function. Step 1: Fill the given required detail in any blank worksheet to use reverse VLookup in Excel with VLookup function Learn all about Excel's lookup & reference functions, such as VLOOKUP, HLOOKUP, MATCH, INDEX and CHOOSE. Vlookup. The VLOOKUP (Vertical lookup) function looks for a value in the leftmost column of a table, and then returns a value in the same row from another column you specify. 1. Insert the VLOOKUP function shown below

The **VLOOKUP** function is one of the staple functions that Microsoft **Excel** users rely upon for finding values in a table. With the **VLOOKUP** function, a value can be looked up in the leftmost column and a related value can be returned from another column. The Syntax for **VLOOKUP** is VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]). Lookup Value: the criteria, which may be an id or. VLOOKUP and INDEX-MATCH formulas are among the most powerful functions in Excel. Lookup formulas come in handy whenever you want to have Excel automatically return the price, product ID, address, or some other associated value from a table based on some lookup value This post will guide you how to vlookup values in a range of cells and then return True or False values in Excel. How to use the VLOOKUP function to vlookup a value in a list of data, and return True or False values in a selected cells.. In Excel, you can use the VLOOKUP function to look for a value in a column in a table and then returns TRUE from a given column in that table if it finds. How to Do a VLOOKUP With Two Spreadsheets in Excel. Excel's VLOOKUP function searches a cell array for data and returns the value from an adjacent cell in the array. The function searches a single sheet by default, but you can set a function in one sheet to search data in another. For example, if one sheet in your. Excel VLOOKUP returning #N/A when values are present. Hot Network Questions Piano: When you change hand position, how do you coordinate finger with note on paper? Intuition about why gravity is inversely proportional to exactly square of distance between objects What.

VLOOKUP Excel 2010. The explanation for how VLOOKUP works in Excel is far more complicated than actually using it. The best thing to do is to get a rough idea of the arguments that VLOOKUP requires, and what it returns to you, and then quickly go on to look at a few VLOOKUP examples There are a lot of ways to compare two lists or columns in Excel. In this article, I am going to compare two columns in excel using VLOOKUP. In one of my previous articles, I discussed How to Compare Two Columns or Lists in Excel where I discussed other methods of comparison.. Before starting the comparison, I will discuss the syntax, arguments, and other necessary things about the VLOOKUP. VLOOKUP and HLOOKUP are two of the most popular formulas in Excel and using them together is one of the first formula combinations that people learn. While using INDEX MATCH for vertical lookups and INDEX MATCH MATCH for matrix style lookups are superior approaches, it's still a good idea to learn this formula combination and add it to your toolkit of lookup approaches VLOOKUP in Excel The VLOOKUP function allows a user to search the very first column in a cell range and return data from a cell in the same row of that range. Download the example to follow along and learn how to use this function

If only the VLOOKUP would accept -1 as the column number, there would be no problem. But, it doesn't. One common solution is to temporarily insert a new column A, copy the column of names to the new column A, populate with VLOOKUP, Paste Special Values, then delete the temporary column A. Excel pros can probably do this move in their sleep Excel vlookup Logg inn for å følge dette . Følgere 0. Excel vlookup. Av cppeders, 25. oktober 2010 i Programvare. Kontorprogramvare; Svar i emnet; Start nytt emne; Anbefalte innlegg. cppeders 0 cppeders 0 Medlemmer; 0 17 innlegg. Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes. Are you still looking for help with the VLOOKUP function? View our comprehensive round-up of VLOOKUP function tutorials here How To Do A VLOOKUP: The Ultimate Guide. If you've spent time with Excel, you've probably heard of VLOOKUP.It's one of the most popular and useful functions you can use on a spreadsheet, and is found in most workbooks that venture beyond simple mathematical functions like SUM and AVERAGE.It makes appearances worldwide in Excel interviews and even analytical assessments like the Uber Excel test VLOOKUP MATCH is one of several possible lookup formulas within Microsoft Excel. This tutorial assumes you already have a decent understanding of how to use VLOOKUP. If you do not, please click here for a beginner's tutorial on VLOOKUP. Objective. VLOOKUP MATCH is an improved variation of your basic VLOOKUP or INDEX MATCH formula

We are excited to announce XLOOKUP, Excel's most powerful lookup function and the successor to the iconic VLOOKUP VLOOKUP is probably the most popular function in Excel, and one of the most helpful functions for everyday use. VLOOKUP helps us lookup a value in table, and return a corresponding value. A good example for VLOOKUP in real life is our Contacts app on the phone: We lookup for a friend's name, and the app returns its number How Excel VLOOKUP Function works? Before using the VLOOKUP, we should first understand the way of function of VLOOKUP. VLOOKUP is designed to retrieve the organised data from vertical rows of table where each row represents a new record