+ Reply to Thread
Results 1 to 2 of 2

LOOKUP, MATCH, INDEX Question. (2 Search Values)

  1. #1
    Registered User
    Join Date
    Texas, USA
    MS-Off Ver
    Excel 2007

    LOOKUP, MATCH, INDEX Question. (2 Search Values)

    i need help with the following situation.
    i have a datasheet that has 3 headers per column.
    so lets say
    A1 2011
    A2 January
    A3 Home
    B1 2011
    B2 January
    B3 Work
    C1 2011
    C2 March
    C3 Home
    X1 2012
    X2 January
    X3 Work

    now i want to add a sheet where i have one cell to enter the Month and another cell to enter the year and one more to enter the type (home/work)
    with that information i want to automatically output specific rows of that date - year - typ combo.
    can someone help me figure this out?
    its greatly appreciated

  2. #2
    Valued Forum Contributor
    Join Date
    United States
    MS-Off Ver
    Excel 2010

    Re: LOOKUP, MATCH, INDEX Question. (2 Search Values)

    Hello there,

    Could you please provide a sample worksheet that shows your original data on one worksheet and your desired outcome on another?


+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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