+ Reply to Thread
Results 1 to 5 of 5

Thread: VLookup

  1. 03-10-2011, 07:27 PM #1
    Angus1
    Angus1 is offline
    Registered User
    Join Date
    03-07-2011
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2003
    Posts
    3

    VLookup

    I'm trying to get the data from one spreadsheet to another, I've entered a vlookup but it's returning the wrong result.
    As you can see from my screenshots, the result I want it to find is 412 but it's returning 308.
    Can you please tell me what I've done wrong here?
    Attached Images Attached Images
    Reply With Quote Reply With Quote
  2. 03-10-2011, 07:40 PM #2
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Cochrane,Alberta
    MS-Off Ver
    XL 2003,2007,2010
    Posts
    6,843

    Re: Why won't my Vlookup work!?!?

    try placing
    ,0 at the end of the 6
    or
    ,false
    Dave-MS Excel MVP
    Reply With Quote Reply With Quote
  3. 03-10-2011, 07:55 PM #3
    Angus1
    Angus1 is offline
    Registered User
    Join Date
    03-07-2011
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Why won't my Vlookup work!?!?

    thanks for the quick response Dave, when I put either of those I get #N/A as a result.

    I'm perplexed!!
    Reply With Quote Reply With Quote
  4. 03-10-2011, 08:07 PM #4
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Cochrane,Alberta
    MS-Off Ver
    XL 2003,2007,2010
    Posts
    6,843

    Re: Why won't my Vlookup work!?!?

    It's hard to tell the range you are using in your formula.
    Dave-MS Excel MVP
    Reply With Quote Reply With Quote
  5. 03-10-2011, 09:12 PM #5
    Angus1
    Angus1 is offline
    Registered User
    Join Date
    03-07-2011
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: VLookup

    I think I may have solved it.
    I needed to put "quotes" around the initial term I was looking for.
    So simple when you know how!
    Reply With Quote Reply With Quote
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.2.0