Skip to main content

What is VLookup?

                                                                            


Introduction :

        VLookup

            The Formula Vlookup in Excel is a powerful and it plays a vital role in many functions such as Generating report, Comparing values, Analyse data and so on...

What is VLookup?

            The Term Vlookup Stands for Vertical Lookup, typically it matches the values vertically from the target location.

            Suppose you want to find values which belongs to your base value then you can get it with the Vlookup formula. Moreover the data should be arranged vertically which on other words in row wise data.

Syntax

   = VLOOKUP(value,table,col_index,[range lookup])

Arguments ( inputs within brackets)

Value  - Base or value to which we need value to get from target.

Table - Target table or location table to get value from.

col_index - Target column from where  we get value.

range lookup - [optional] TRUE = approximate match (default). FALSE = exact match.



Thanks,

Gokul Tech Team.


Labels:

Comments

Post a Comment

Popular posts from this blog

Understanding the DATESINPERIOD Function in Power BI

                                              Power BI is a powerful business analytics tool by Microsoft that helps users visualize data and share insights across their organization. One of the key features of Power BI is its ability to handle time-based data with ease, thanks to its robust suite of time intelligence functions. Among these, the DATESINPERIOD function is particularly useful for analyzing data over specific time periods. In this blog post, we'll dive deep into the DATESINPERIOD function, exploring its syntax, usage, and practical applications.  What is the DATESINPERIOD Function?                         The DATESINPERIOD function is a DAX (Data Analysis Expressions) function used to return a table of dates shifted by a specified number of intervals (day...
Post a Comment
Read more

What is Database

  Definition:                A database is an organized collection of structured information, or data, typically stored electronically in a computer system. A database is usually controlled by a  database management system (DBMS) .  What is Data?               Data is a raw or unprocessed information. Typically, the data is raw and there is no statistical or any analysis made before to understand whether it is a real one or not. Example:                    We are using smartphones with many social media applications. Each and every message as in the form of text, images (irrespective of formats), documents (irrespective of formats), links everything considered as Data.                      It can be processed by organizations, individuals or any other in need according t...
Post a Comment
Read more

DBMS Vs RDMBS

  Definition of DBMS:                    DBMS stands for DataBase Management System, which is a software system used to make CRUD Operations in the Database.  What is  CRUD??                    C - C reate                    R - R etrieve                 U - U pdate                    D - D elete                              all these actions are taken on the database to make changes as per the requirement from end user. Types of DBMS:     a) Flat File     b) Hierarichal     c) Network     d) Relational     e) Non - Relational What is Relational DBMS?         ...
Post a Comment
Read more