Results 1 to 5 of 5
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ghost on lookup (2000)

    See in macro CONTROLLO_VALORI
    why the lookup return the value above instead correct value?????

    100
    100
    100
    100
    100
    200
    200
    300
    300
    300
    300
    300
    300
    300
    400
    400

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: ghost on lookup (2000)

    Please explain what the "correct value" should be and why.

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ghost on lookup (2000)

    In effect i want to macth column AB sheet T374 with column C of sheet TOTALI and return in column AG sheet T3574 the value faund in L of sheet TOTALI...

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: ghost on lookup (2000)

    Yes, that is what your macro does as far as I can tell. What exactly is the problem? Please try to be specific.

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: ghost on lookup (2000)

    I agree with Hans I get what I would expect and this matches the values i get using the VLookup Formula your code tries to emulate...

    Steve

Posting Permissions

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