Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: Combine Data in two Sheets Using VLookup "#N/A" Error

  1. #1
    New Member
    Join Date
    Jul 2007
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Combine Data in two Sheets Using VLookup "#N/A" Error

    I'm trying to use Excel V10 to combine data in two sheets and having a devil of a time. I'm trying to do this column by column but my ultimate goal is to pull several columns into my sheet by keying a common identifer in both. I did the following:

    1. Names each sheet
    2. Changed the entire number format to "general" for both sheets
    2. Used the formula function in excel to create the vlookup. the formula looks like > =VLOOKUP(J2,'Add Data'!A1:S7422,14,FALSE)

    After I do this get the "#N/A" error.

    What should I do? Also, if there is a simple way to key on the one common data in both sheets and then pull multiple columns, I'd love to hear how.

    Many thanks,
    Scomar

  2. #2
    Board Regular
    Join Date
    Jan 2012
    Posts
    254
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Combine Data in two Sheets Using VLookup "#N/A" Error

    Can you provide a sample workbook of what you want to achieve? Remove sensitive information.

    Thanks

  3. #3
    Board Regular Drrellik's Avatar
    Join Date
    Apr 2013
    Location
    East Coast, South Carolina
    Posts
    731
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Combine Data in two Sheets Using VLookup "#N/A" Error

    I suspect that your values are not the same. look at this link and see if you can find your error. If not please post some of your data. Why Does VLOOKUP Return An #N/A Error? | RAD Excel Don

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    85,057
    Post Thanks / Like
    Mentioned
    44 Post(s)
    Tagged
    9 Thread(s)

    Default Re: Combine Data in two Sheets Using VLookup "#N/A" Error

    Quote Originally Posted by scomar411 View Post
    I'm trying to use Excel V10 to combine data in two sheets and having a devil of a time. I'm trying to do this column by column but my ultimate goal is to pull several columns into my sheet by keying a common identifer in both. I did the following:

    1. Names each sheet
    2. Changed the entire number format to "general" for both sheets
    2. Used the formula function in excel to create the vlookup. the formula looks like > =VLOOKUP(J2,'Add Data'!A1:S7422,14,FALSE)

    After I do this get the "#N/A" error.

    What should I do? Also, if there is a simple way to key on the one common data in both sheets and then pull multiple columns, I'd love to hear how.

    Many thanks,
    Scomar
    Does J2 occur many times or just once on Add Data?
    Assuming too much and qualifying too much are two faces of the same problem.

  5. #5
    New Member
    Join Date
    Jul 2007
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Combine Data in two Sheets Using VLookup "#N/A" Error

    I'm not sure how to load a workbook. I've read the FAQ but it is not clear how to use the HTML function to load a sheet. Any advice...sorry.

  6. #6
    Board Regular
    Join Date
    Jan 2012
    Posts
    254
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Combine Data in two Sheets Using VLookup "#N/A" Error

    you can use dropbox, google docs or other similar

  7. #7
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    85,057
    Post Thanks / Like
    Mentioned
    44 Post(s)
    Tagged
    9 Thread(s)

    Default Re: Combine Data in two Sheets Using VLookup "#N/A" Error

    Can you answer the question posed in post #4?
    Assuming too much and qualifying too much are two faces of the same problem.

  8. #8
    New Member
    Join Date
    Dec 2013
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Combine Data in two Sheets Using VLookup "#N/A" Error

    Quote Originally Posted by scomar411 View Post
    I'm trying to use Excel V10 to combine data in two sheets and having a devil of a time. I'm trying to do this column by column but my ultimate goal is to pull several columns into my sheet by keying a common identifer in both. I did the following:

    (...)

    Many thanks,
    Scomar
    Could be the order of data, these data must be classified by A to Z or 0 to 9... Another item is, if the column data (where are you looking the value) has a repeated data value, it could generate this kind of error...

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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