+ Reply to Thread
Results 1 to 2 of 2

Lookup/ Return and concatenate values based upon multiple criteria

  1. #1
    Registered User
    Join Date
    03-21-2013
    Location
    Utah
    MS-Off Ver
    Excel 2010
    Posts
    2

    Lookup/ Return and concatenate values based upon multiple criteria

    I am attempting to make a vacation calendar.

    I am looking to take a date cell and check if it is within a user entered date range. If so, I want it to return and concatenate all employees that were on vacation for that day. I am having 2 main issues. I cannot seem to place a criteria to only pull vacation that is not cancelled and I cannot seem to create a formula that will match the criteria and concatenate all returned values. However, I am leaning towards removing the cancellation entry type and instead just deleting/ altering entries whenever a cancellation request is made.

    I have attached a document that resembles what I am working on. Ideally, this will allow the user to select the month on the calendar and it will be updated automatically with data pulled from the Vac Days sheet (Vacation table). The calendar 2 sheet shows what I envision, ideally.

    I am open to any and all suggestion as I have been beating my head against this project for a few days. Also, I am not against VBA, but consider myself green and learning.

    Thanks!

    Vacation.xlsm

  2. #2
    Registered User
    Join Date
    03-21-2013
    Location
    Utah
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Lookup/ Return and concatenate values based upon multiple criteria

    This post has quite a few views, does anyone have any thoughts that may prove helpful?

+ 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