+ Reply to Thread
Results 1 to 5 of 5

Vlookup always giving n/a as result

  1. #1
    Registered User
    Join Date
    09-11-2010
    Location
    India
    MS-Off Ver
    Excel 2007, Excel 2010
    Posts
    3

    Vlookup always giving n/a as result

    On sheet2, i have put vlookup function to get the option price from sheet1. Whenever i try to find the CALL price its gives me N/A as result and gives proper result for PUT price. Kindly help.
    Attached Files Attached Files
    Last edited by ankit_85; 09-11-2010 at 01:28 AM.

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Vlookup always giving n/a as result

    The value you're looking for (5100) isn't in column "C", it is in column "J" however. VLOOKUP will only search in the leftmost column.

    Cheers,
    Last edited by ConneXionLost; 09-11-2010 at 01:10 AM.
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

  3. #3
    Registered User
    Join Date
    09-11-2010
    Location
    India
    MS-Off Ver
    Excel 2007, Excel 2010
    Posts
    3

    Re: Vlookup always giving n/a as result

    So wat can be done to get the correct answer?

  4. #4
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Vlookup always giving n/a as result

    Try INDEX & MATCH instead:

    Please Login or Register  to view this content.
    Cheers,

  5. #5
    Registered User
    Join Date
    09-11-2010
    Location
    India
    MS-Off Ver
    Excel 2007, Excel 2010
    Posts
    3

    Re: Vlookup always giving n/a as result

    Thanks a lot...!!!

+ 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