+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    Registered User
    Join Date
    09-29-2010
    Location
    Texas, USA
    MS-Off Ver
    Excel 2007
    Posts
    11

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

    Hello
    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?
    thanks
    its greatly appreciated

  2. #2
    Valued Forum Contributor
    Join Date
    03-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1,093

    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?

    Thanks!

+ 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