What's up with this?
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: What's up with this?

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     

    I'm using VLOOKUP to do a query which is:

    =VLOOKUP("Dan Howell",A1:F46,2)

    which seems to be fine, except that whenever the position of Dan Howell changes I get #N/A? Does anyone know why and how I can stop it?

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    232
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Does Dan move from the range you have in your lookup?

  3. #3
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Joe

    Use the Lookup_range argument and set it to False.


    =VLOOKUP("Dan Howell",A1:F46,2,False)


  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      

    Well, the position of Dan changes from day to day. It worked fine when I first put the formula in, but the next day it said #N/A when the position of Dan changed.

    However, the formula that Dave Hawley just put on works fine. Dave, you are so the man, why are you not an MVP?

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