+ Reply to Thread
Results 1 to 5 of 5

Vlookup function not working

  1. #1
    Registered User
    Join Date
    07-07-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Post Vlookup function not working

    Hi,
    Need a help in making a vlookup function working in one of my sheets. Appreciate a quick response.
    I have attached the file with this post. Cell with vlookup function is highlighted with yellow cell color.

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Vlookup function not working

    Use the below. file attached.

    =INDEX(O:P,MATCH(C2,P:P,0),1)
    Attached Files Attached Files
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Vlookup function not working

    lets explain why
    =VLOOKUP(C2,$O$2:$P$81,16,FALSE)

    this says look for the value in c2 in range O$2:$P$81 column 16 exact match
    now the first thing is
    O$2:$P$8 is only 2 columns so column 16 doesnt exist
    v lookup looks in the first columm of the range only ie O2:081
    now your column $O$2:$O$81 only contains numbers whereas c2=Multiplexer
    it looks like you are trying to match c2 with column $P$2:$P$81 and get back what is in $O$2:$O$81 vlookup as it stands wont do that .you can use index/match as shown above or even
    =VLOOKUP(C2,CHOOSE({1,2},$P$2:$P$81,$O$2:$O$81),2,FALSE)
    Last edited by martindwilson; 07-07-2012 at 06:15 AM.
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  4. #4
    Registered User
    Join Date
    07-07-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Vlookup function not working

    Thanks guys.

  5. #5
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Vlookup function not working

    If your problem is soved, please mark the thread as solved

    To mark your thread solved do the following:
    - Go to the first post
    - Click edit
    - Click Advance
    - Just below the word "Title:" you will see a dropdown with the word No prefix.
    - Change to Solve
    - Click Save

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1