+ Reply to Thread
Results 1 to 7 of 7

Attributing values from external source

  1. #1
    Registered User
    Join Date
    05-20-2014
    Posts
    5

    Question Attributing values from external source

    Hello,
    I have this problem, I've tried to look up the solution but I didn't manage to find anything that would help me to solve it.
    I have a big excel sheet with number plates and attributed to them: velocity, times, dates, etc. In the second external source i have csv with another data, now without anything more than number plate & car type. I want to merge this data in the way that i would have information of car type in the excel worksheet with number plates and dates (so essentially merge the second with the first.
    It's more than possible that in the second file number plates will be attributed to more than one type of car, as this process was done automatically.
    I really cannot wrap my head around this, even how to approach this problem. Files are gigantic, so no way of doing it manually.
    I'd really appreciate any help.
    Regards,
    fea

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Attributing values from external source

    Use VLOOKUP?
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,067

    Re: Attributing values from external source

    Hi feanar,

    You could use a VLOOKUP Formula using the number plate value as the common field between both datasets.

    Can you post some example files to help understand the problem?

    Thanks
    Remember you are unique, like everyone else

  4. #4
    Registered User
    Join Date
    05-20-2014
    Posts
    5

    Re: Attributing values from external source

    Well, thanks! it works, but not as i good as i need it. It sometimes returns invalid data. When searching in the CSV file, for a number plate which doesnt exist there it returns simply false data. Sometimes, when it returns first row, its ok, i can get rid of it, because thats the title of the column, but it returns false data.
    In other words it says for example that number plate KP32642 is a mercedes, when in fact it doesnt exist in the array table, so it couldnt lookup for it there.
    I think it has something to do with the ascending order which is not preserved as these number plates are strings (or should i do this order anyway?)
    Anyway, big thanks for fast and accurate answer, if u could only give me some hints about this additional problems.
    I'm also sorry, but i can't post this data because it's real and i do not own it.
    Regards,
    fea

  5. #5
    Forum Contributor Jack7774's Avatar
    Join Date
    08-31-2012
    Location
    Georgia, US
    MS-Off Ver
    Excel 2010
    Posts
    576

    Re: Attributing values from external source

    An example worksheet does wonders for clarity. Don't use the real data however make up at least 5 lines or so and then upload the spreadsheet.
    Thank those who have helped you by clicking the Star * below their name and please mark your post [SOLVED] if it has been answered satisfactorily.

  6. #6
    Registered User
    Join Date
    05-20-2014
    Posts
    5

    Re: Attributing values from external source

    Big thanks for help guys.
    I got rid of duplicates and the problem disappeared.
    Regards,
    fea

  7. #7
    Forum Contributor Jack7774's Avatar
    Join Date
    08-31-2012
    Location
    Georgia, US
    MS-Off Ver
    Excel 2010
    Posts
    576

    Re: Attributing values from external source

    Nice. Don't forget to thank those who've helped by adding rep. I'm glad everyone could help resolve get your desired solution.

+ 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. Replies: 5
    Last Post: 03-26-2014, 08:30 AM
  2. Replies: 1
    Last Post: 07-07-2011, 11:17 AM
  3. external source is not available
    By SJDANIELS in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-14-2009, 01:43 PM
  4. Attributing Values and multiplication
    By Sionos in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-25-2007, 09:30 AM
  5. Attributing a range scale to a percentage.
    By WLM1976 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-23-2006, 09:23 AM

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