Results 1 to 3 of 3

Thread: Vertical and Horizontal Lookup Using Match And Index Function

  1. 07-31-2013, 08:35 PM #1
    sarah
    sarah is offline
    Junior Member
    Join Date
    Jul 2013
    Posts
    3
    Rep Power
    0

    Vertical and Horizontal Lookup Using Match And Index Function

    Hi All

    I'm struggling with this excel formula.. I have two sheets and trying to extract the result in Column D in sheet 1 based on the choices made in Columns B & C drop down lists (Username and Status).. I've attached my file.. For example when I select "al2" in Column B and "Days Since Change" in Column C I would get "20".. I wasn't able to make this happen and get the result I want in Column D

    Any help is greatly appreciated.. I've attached my file
    Workbook1.xlsx


    Thanks
    Reply With Quote Reply With Quote
  2. 07-31-2013, 09:37 PM #2
    Excel Fox
    Excel Fox is offline
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Sheet1!D2=INDEX(Sheet2!$C$2:$E$8,MATCH(Sheet1!B2,S heet2!$B$2:$B$8,0),MATCH(Sheet1!C2,Sheet2!$C$1:$E$ 1,0))

    and drag down
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook
    Reply With Quote Reply With Quote
  3. 07-31-2013, 09:59 PM #3
    sarah
    sarah is offline
    Junior Member
    Join Date
    Jul 2013
    Posts
    3
    Rep Power
    0
    you're the best!! thanks for resolving my 10+ hours of pain, you made my day
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Match And Index Formula To Lookup Data From Table
    By srizki in forum Excel Help
    Replies: 7
    Last Post: 07-26-2013, 06:34 PM
  2. Staffing Scheduling HELP Match/Index
    By mgelston in forum Excel Help
    Replies: 2
    Last Post: 06-20-2013, 01:09 AM
  3. Use Native Excel Function Lookup Formula In VBA
    By ramananhrm in forum Excel Help
    Replies: 8
    Last Post: 05-03-2013, 09:10 AM
  4. Lookup On Multiple Columns And Return Result Using Match Index
    By nikhil83 in forum Excel Help
    Replies: 4
    Last Post: 04-24-2013, 10:04 AM
  5. Lookup All Corresponding Values Match Criteria In Adjacent Column Array Formula
    By d380013 in forum Excel Help
    Replies: 16
    Last Post: 04-19-2013, 08:20 PM

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
  •  

Forum Rules