+ Reply to Thread
Results 1 to 10 of 10

Vlookup returning incorrect result?

  1. #1
    Registered User
    Join Date
    08-17-2009
    Location
    London,England
    MS-Off Ver
    Excel 2003
    Posts
    7

    Vlookup returning incorrect result?

    Guys,

    I have an issue whereby vlookup is returning incorrect data.

    I have a named data range on worksheet "prices" that is called from a drop down box on another worksheet, so you get a drop down list with all of the item names.

    Next to the item names on the first page is the price of that particular item.

    Next to the drop down box on the second worksheet is a vlookup that looks at the value of the drop down box, and takes the value in column 2 of the afordmentioned sheet.

    The vlookup returns the wrong value in some cases. My understanding is that with:

    =VLOOKUP(A37,Prices!H14:I53,2)

    Excel SHOULD look at whats in A37. It then looks on the Prices worksheet in cells H14:I53. When it finds what it found in A37 within that range, it returns the data in column I (column 2) that is next to the matched item.

    However, if you look at the spreadsheet, try selecting "tungsten carbide Armor" and youll see its actually returning the price for "Titanium Diborate Armor" if you refer to the "prices" worksheet.

    What is going on, can anyone help? Theres quite a few doing this!

    Spreadsheet attached, apologies if its agianst the rules. Theres nothing important or sensitive in there.
    Attached Files Attached Files
    Last edited by Delarado; 08-19-2009 at 06:52 AM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: Vlookup returning incorrect result?

    See XL Help re: optional final parameter of Range_Lookup, you need:

    =VLOOKUP(A37,Prices!H14:I53,2,FALSE)

  3. #3
    Registered User
    Join Date
    08-17-2009
    Location
    London,England
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Vlookup returning incorrect result?

    Apologies, the two worksheets relevant are "prices" and "ballistic"

    Cell concerned is A37 for the drop down and B37 for the vlookup on the "ballistic" worksheet. On the Prices worksheet, CTRL+F3 it to see the range the drop down looks at (components)

    Any other questions let me know. Plan is to make a working formula in B37 and replicate it for the rest.

  4. #4
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,325

    Re: Vlookup returning incorrect result?

    Hi,
    if WTF means what I think, please avoid coarse language - Thx

  5. #5
    Registered User
    Join Date
    08-17-2009
    Location
    London,England
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Vlookup returning incorrect result?

    Quote Originally Posted by DonkeyOte View Post
    See XL Help re: optional final parameter of Range_Lookup, you need:

    =VLOOKUP(A37,Prices!H14:I53,2,FALSE)
    I <3 you.

    Thanks for the ever so speedy response!

  6. #6
    Registered User
    Join Date
    08-17-2009
    Location
    London,England
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Vlookup returning incorrect result?

    Quote Originally Posted by arthurbr View Post
    Hi,
    if WTF means what I think, please avoid coarse language - Thx
    edited out. Sorry

  7. #7
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: Vlookup returning incorrect result?

    Yes - apparently I even have my own church if people wish to worship...

    http://www.excelforum.com/2147144-post9.html


  8. #8
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,325

    Re: Vlookup returning incorrect result?

    Quote Originally Posted by Delarado View Post
    edited out. Sorry


    Np thanks for changing

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1