Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: What does this part of the formula mean?

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    362
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    =VLOOKUP(A2,Sheet2!$A$2:$B$1000,2,0)

    What does the "2" and the "0" at the end of this formula mean? I have seen board members mention changing these last 2 numbers to suite your individual needs but, i don't know what these numbers do.

    Please advise.

    Thx,
    Noir

  2. #2
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The 2 in the formula is the column number in the lookup table you wish to return data from. The 2 means the 2nd column. The 0 is short for FALSE. A 1 would be the same as TRUE. When FALSE is chosen, Excel only returns a value when an EXACT match is found.

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    362
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Lenze!

  4. #4
    Board Regular
    Join Date
    Apr 2002
    Location
    Wivenhoe, England
    Posts
    912
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Beat me to it Lenze. Unhelpfully, the online Excel help does not explain that 0 can be typed instead of FALSE as the range_lookup.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •