Results 1 to 3 of 3

Thread: XL97 to XL2010 help on VLookup and Match
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jun 2012
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default XL97 to XL2010 help on VLookup and Match

    Hello folks,
    Hopefully someone could help me with my problem. I've been using XL2000 windows xp in my office computer and haven't upgrade to 2010. Sadly I'm going on vacation and I'm bringing my work with me and the only available to me is my son's laptop with XL2010 and Windows 7 ..

    So here's my problem my vlookup /match (cell AB) formulas are giving me errors at XL2010



    it picks up draws from another worksheet/pivot table.

    and I evaluated the formula in XL 2010 and this is what I coming up in the popup window



    So I'm really not sure where to start as I'm not really keen in rewriting formulas especially complicated ones like these..

    So any help will do..Thank you and have a nice day.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: XL97 to XL2010 help on VLookup and Match

    That "D5" in the MATCH formula is invalid. Not sure what Excel 2000 is doing, but it can only be a -1, a 0 (most likely what you need) or a 1.
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    New Member
    Join Date
    Jun 2012
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: XL97 to XL2010 help on VLookup and Match

    Many Many Thanks Juan Pablo...you're a good man..That works! Dinner's on me

    Btw..just checked your website..great photos!

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
  •