+ Reply to Thread
Results 1 to 7 of 7

Problem with Vlookup - have value in sheet but show error #N/A

  1. #1
    Registered User
    Join Date
    02-04-2010
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    20

    Problem with Vlookup - have value in sheet but show error #N/A

    hi frends,

    I had searched forum and can't get my answer.. may be i can't get that thread.. today is sunday and i am in office, and have lots of work and pressure, i have to show data to my boss tomorrow

    Thats why i am starting this thread... sorry

    I am facing problem with vlookup
    i have a good hand on vlookup..
    but don't know what happened....

    Problem
    there is two sheets/workbook both sheets/workbook contains same value
    but don't know why the error showing #N/A... when i continue with same formula.. its comes corectly
    i mean i have to do 7 - 8 times vlookup

    Example
    sheet contains 100 row
    1st time i get result of 20 rows
    2nd time i get result of 10 rows
    3rd time i get result of 10 rows
    and go on.....

    everytime i am sorting column and doing vlookup

    what is the problem frends ?

    pls help me..

    Thanx

  2. #2
    Forum Contributor
    Join Date
    03-11-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    694

    Re: Problem with Vlookup - have value in sheet but show error #N/A

    you plz upload a sample of your workbooks...i or somebodyelse will surely help

  3. #3
    Registered User
    Join Date
    02-04-2010
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: Problem with Vlookup - have value in sheet but show error #N/A

    Thanks Rohan for your reply...

    Attached is a test sheet....

    In Sheet1 in column D and F and i want value from sheet2

    Thanx
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,886

    Re: Problem with Vlookup - have value in sheet but show error #N/A

    Row 32:
    Is looking for 10022 in range A32:C293
    But 10022 stand in A16
    So he can't find it.
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  5. #5
    Registered User
    Join Date
    02-04-2010
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: Problem with Vlookup - have value in sheet but show error #N/A

    Thanks for your reply frend

    Yes its work now....

    i have to select whole column for getting value...

    but frend sometimes its shows error (not rememeber exactly) Error : there is enough range 256 -something like this
    thats why i vlookup in rows not in column - i hope u get what i am trying to say...

  6. #6
    Registered User
    Join Date
    06-21-2012
    Location
    Surrey, England
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: Problem with Vlookup - have value in sheet but show error #N/A

    Hi

    The reason why the VLook Up function is giving you a number of incorrect results is because you have not applied the 'absolute cell references' (ie: inserting the dollar signs to the cell ranges) to your cell ranges. As you'll see from the attached file (columns H and I), I have done this for you. I have also come across six codes listed in sheet 1 that are not included in sheet 2. This explains why the VLook Up function is unable to locate them. To view these, you'll need to filter for "Code not found in Sheet 2" in the column header for columns H and I.

    I hope your boss won't give you any grief tomorrow.

    Hope this helps.

    Peter
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    10-11-2012
    Location
    tehran
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Problem with Vlookup - have value in sheet but show error #N/A

    Here's Your Solution:
    just Replace Your Formula In D2 with : =VLOOKUP(A2,Sheet2!$A$2:$C$263,3,0)
    And In F2 With : =VLOOKUP(A2,Sheet2!$A$2:$D$263,4,0)
    and Drag it down to all cells

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Error in formula to show sheet name
    By tryckman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-09-2012, 03:49 PM
  2. not to show error when using if(isna & vlookup)
    By mingali in forum Excel General
    Replies: 2
    Last Post: 04-07-2010, 10:51 AM
  3. Vlookup problem - Getting error results
    By neil_a in forum Excel General
    Replies: 4
    Last Post: 01-28-2010, 10:24 AM
  4. problem macro to show a warning sheet...
    By quartz in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-02-2005, 06:20 PM
  5. [SOLVED] problem macro to show a warning sheet...
    By Pierre via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-02-2005, 06:17 PM

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