+ Reply to Thread
Results 1 to 3 of 3

lookup 2 values and return multiple results

  1. #1
    Forum Contributor
    Join Date
    10-01-2008
    Location
    Eureka, CA
    Posts
    161

    lookup 2 values and return multiple results

    Hi. I need a formula that will look up data based on matching 2 criteria. The first criteria is client name and the 2nd is month. The list of data has specific dates, but the look up will just be the name of the month and year, so all dates from that month and year will be returned.

    Lookup Values
    (sheet2!G8) = Client Name
    (sheet2!C14) = Month

    Data Ranges
    (sheet4!A:A) = List of client names
    (sheet4!B:B) = List of dates

    I have attached a sample....results are returned to sheet4, I have labeled sheet 4 with the cells that are lookup and each cell where i need formula.
    Attached Files Attached Files

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: lookup 2 values and return multiple results

    You could try creating a helper column on your first sheet which concatenates the person and month.

    e.g.

    Please Login or Register  to view this content.
    This then gives a single value that you can use in a lookup function.
    Martin

  3. #3
    Forum Contributor
    Join Date
    10-01-2008
    Location
    Eureka, CA
    Posts
    161

    Re: lookup 2 values and return multiple results

    mrice, the thing is that the data list has specific dates (04/01/10) but i want the lookup value to be just the month(april). not sure how to achieve this.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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