1. James Falconer's Avatar
    Can someone explain the syntax of VLOOKUP to me (in excel) and how it's best used?
    03-23-2017 10:41 AM
  2. anthonyng's Avatar
    @James Falconer It's awesome...

    In a very simple example

    Say you have a list of information like usernames on sheet1. And say you have a list of usernames and their FULL names on another sheet2.

    Say you need to grab the full names from sheet2 to put onto sheet1. so vlookup helps by checking the username in sheet1, finds it in sheet2 and matches it up and brings in the value of the full name. (lets also assume they are in complete different order, or you have less username in sheet1 than sheet2 and you can't simply just copy paste )

    V is for vertical, so you need to have the data going vertical. It's best to have the look up side (sheet2) unique, as it will go and retrieve the first one it finds.

    The range you are looking for the data, the first column you indicate needs to be the on your trying to match, then the retrieval column # is whatever column the data you want is in. Sometimes you select a big range of data and fullname could be column2 of your selection, or column10 even... Depends on how the source is connected.. The last param of true or false, I always use FALSE to make it match exactly. I don't have much of a use case for TRUE.
    raycpl and jmshub like this.
    03-23-2017 10:58 AM
  3. nickx91's Avatar
    VLOOKUP can be referred as Vertical Lookup in a given data. Microsoft defines VLOOKUP as:

    In its simplest form, the VLOOKUP function says:

    =VLOOKUP(Value you want to look up, range where you want to lookup the value, the column number in the range containing the return value, Exact Match or Approximate Match – indicated as 0/FALSE or 1/TRUE).

    Source: Microsoft

    You can use VLOOKUP as:

    =VLOOKUP(lookup value, range containing the lookup value, the column number in the range containing the return value, optionally specify TRUE for approximate match or FALSE for an exact match).
    jmshub likes this.
    07-10-2017 07:25 AM
  4. tgp's Avatar
    Excel also has an HLOOKUP (Horizontal) function, but it is seldom used, due to how spreadsheets are normally set up.

    The last param of true or false, I always use FALSE to make it match exactly. I don't have much of a use case for TRUE.
    I've never used TRUE either, and I don't recall ever seeing it used. I've tried it, but it's a bit too general and includes too much to make it useful for me.
    07-10-2017 10:00 AM

Similar Threads

  1. Winphone 8.1: Can't turn off Navigation Keys from Settings. What should I do?
    By Windows Central Question in forum Ask a Question
    Replies: 2
    Last Post: 11-12-2017, 09:18 AM
  2. What is the best way to set up a new 950
    By Archdean in forum Microsoft Lumia 950
    Replies: 4
    Last Post: 03-23-2017, 01:34 PM
  3. This is the difference between VR and AR
    By WindowsCentral.com in forum Windows Central News Discussion
    Replies: 1
    Last Post: 03-23-2017, 12:27 PM
  4. Wordbrain is like hide-and-seek, but with words
    By WindowsCentral.com in forum Windows Central News Discussion
    Replies: 0
    Last Post: 03-23-2017, 10:10 AM
  5. Looks like my Neo is on it's last legs
    By Rod Iron in forum Samsung ATIV S Neo
    Replies: 0
    Last Post: 03-23-2017, 05:50 AM
LINK TO POST COPIED TO CLIPBOARD