VLOOKUP returning a BOOL
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: VLOOKUP returning a BOOL

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Location
    Australia
    Posts
    52
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    is it possible for VLOOKUP to return a boolean value, say:
    IF the value exists in the column you are "VLlooking up" then it will return true. This would then aid in using it within an IF statement. So Iff value exists, then do this, if it doesnt, then do something else....

    this is my code so far
    =VLOOKUP(A5,week1.xls!$A$1:$A$10,1,0)

    any help would be much appreciated. Thanx a lot.

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,854
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

    On 2002-04-12 03:32, KnAsTa wrote:
    is it possible for VLOOKUP to return a boolean value, say:
    IF the value exists in the column you are "VLlooking up" then it will return true. This would then aid in using it within an IF statement. So Iff value exists, then do this, if it doesnt, then do something else....

    this is my code so far
    =VLOOKUP(A5,week1.xls!$A$1:$A$10,1,0)

    any help would be much appreciated. Thanx a lot. [img]/board/images/smiles/icon_smile.gif[/img]
    Better use MATCH for that option like in:

    =ISNUMBER(MATCH(E1,G1:G10,0))


  3. #3
    Board Regular
    Join Date
    Apr 2002
    Location
    Australia
    Posts
    52
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    hrm.........could you please elaborate on the MATCH statement, and ISNUMBER statement. I do not understand. Sorry

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,854
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

    On 2002-04-12 03:53, KnAsTa wrote:
    hrm.........could you please elaborate on the MATCH statement, and ISNUMBER statement. I do not understand. Sorry
    MATCH returns a row or column number if it succeeds to find a value that matches its lookup value, otherwise #N/A.

    =ISNUMBER(7) returns TRUE

    =ISNUMBER(#N/A) returns FALSE.


  5. #5
    Board Regular
    Join Date
    Apr 2002
    Location
    Australia
    Posts
    52
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    thanks a lot, that really helped. Cheers

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
  •  

 

 
DMCA.com