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
Bookmarks