Results 1 to 6 of 6

Modifying "vloookup" function for a specific task. Help needed.

Threaded View

  1. #1
    Registered User
    Join Date
    01-27-2011
    Location
    Novi Sad, Serbia
    MS-Off Ver
    Excel 2010
    Posts
    62

    Question Modifying "vloookup" function for a specific task. Help needed.

    Hi to all.

    I have needs for specific functionality in Excel, which cant be accomplished with some built in functions and features, so Im guessing that I need to make specific macro or to add new functionality in the form of some plugin maybe. As I'm doing this for the 1st time, any suggestion and help is highly appreciated.

    So here is the detailed explanation of what I would like to accomplish:

    I have 2 different excel files, and they are even stored on a different PCs in my LAN.
    One file has table of my products. Each product consists of the flowing columns: name of the product, its unique code, supplier name, retail prize.
    On the other PC I have same table with the same column name, just different content.

    What I would like to do is compare these to files, in order to look for the match and for that I use VLOOKUP function.
    So function takes the product code in one file and searches the 2nd file for that same code. When it finds code matching it returns the supplier name from the 2nd file which is in the column next to product code. This works perfectly fine.

    Problem is that I only get first match, and later on there could and most of the time there are other matches later on in the table.
    Result is always returned in the first file in one cell so there is no problem there, but what I want to do is to return all the matches in that same cell so I would need some sort of drop down list for that cell. That is the major question here. Am I able to do so and how?

    I made one example file so you can check it out. It would be much easier to see what I'm looking from the example.
    Please note that I used only one file for the example and that these 2 tables would be in the 2 different files in the real situation.
    If you need any further information and details please, ask, I will provide them asap.

    Any suggestion is highly appreciated, thanks.
    Dean

    example >>> exampleVLOOKUP.xlsx

    EDIT: I use MS Office 2010.
    Last edited by Dolke; 01-13-2013 at 03:47 AM. Reason: Adding my MS office version.

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