+ Reply to Thread
Results 1 to 2 of 2

To get multiple output from a Vlookup in a single cell

  1. #1
    Registered User
    Join Date
    08-04-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    1

    To get multiple output from a Vlookup in a single cell

    Hi All,

    I am trying to work on a tracker sheet which involves getting the list of assignments listed down based on their completion date. The attachment has details and format. The base sheet is the data which I have exported from MS Project and I want to convert this data into the Top sheet.

    I have tried VLOOKUP function to get the details of the assignments done in one month but it is not giving multiple outputs.Moreover I would like this output in a single Cell if possible.

    I am also not able to compare the dates from both the sheets as the date format is different. I am converting all the end date to one particular date and then comparing.

    Kindly advise on how to proceed in this..

    Regards,
    Murthi
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: To get multiple output from a Vlookup in a single cell

    I can *nearly* help you.

    I've been scratching my head about this UDF:

    Please Login or Register  to view this content.
    It should find all matches of the search term in a given range and concatenate all of the cells a certain offset from each match, and if it's called from a macro it works fine, but if you use it as a UDF it returns Nothing from the .FindNext

    Maybe one of the gurus here can fix it and then it should do what you want.

+ Reply to Thread

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