Results 1 to 5 of 5

Look up a value with multiple criteria. Theoretically should be a simple INDEX/MATCH!

Threaded View

  1. #1
    Registered User
    Join Date
    02-13-2012
    Location
    London, Canada
    MS-Off Ver
    Excel 2007
    Posts
    3

    Look up a value with multiple criteria. Theoretically should be a simple INDEX/MATCH!

    This is not that difficult, I am certain... In fact, I am pretty sure I had the formula and then my computer died and now I can’t figure it out again.

    I believe it should be a fairly straightforward INDEX/MATCH formula; I want to return a value from an array on a separate worksheet, using two criteria. More specifically, the two criteria are an employee name and a date and the value being returned would be the info on whether they worked that day, were off, were on vacation, etc. (See attached example)

    What I thought was working, 30 seconds prior to my computer battery dying, was something along the lines of:

    =INDEX(Sheet2!A1:K25, MATCH(B2,Sheet2!A1:K1,0),MATCH(A3,Sheet2!A1:A25,0))
    However, now that formula seems to be returning random values; values that are found in the array, but are not from the correct cell. I have left the formula in one column of the attached example so you can see what I mean.

    I really appreciate this forum and thank you all in advance for your help!

    P.S. I am using Excel 2007
    Attached Files Attached Files

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