Closed Thread
Results 1 to 4 of 4

Return Headers Based On Two Values

  1. #1
    Registered User
    Join Date
    09-27-2012
    Location
    Maryland
    MS-Off Ver
    Excel 2007
    Posts
    10

    Return Headers Based On Two Values

    Regards All,

    I am working on Vendor Rebate Schedules and I need to somehow translate vendor's schedules into our own upload-able schedules for purchase systems. I need to return Months based on two values ProductCode and Percent available for those months. How is it possible using Index and Match fucntion?Attached file has two tabs VendorSchedule and InternalSchedule and I need to return Months on the InternalSchedule.

    Thank you all.

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Return Headers Based On Two Values

    Is this a duplicate post:

    http://www.excelforum.com/excel-gene...wo-values.html
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Registered User
    Join Date
    09-27-2012
    Location
    Maryland
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Return Headers Based On Two Values

    Hi Tony,

    Yes, it's duplicated and need to delete this one.

    Thanks.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: Return Headers Based On Two Values

    Duplicate thread...closed
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

Closed 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