Lookup with Multiple Criteria

Hi All,

So I'm good with Index Match Match. However I've hit a tough spot with something a little bit different.

I've included an example of what i'm after. I just want to look up a date, with that date it'll either be a day or night shift(so I have to break it down again there), and then I want to look up a name and then i'll have the information from the intersecting cells.

Can it done? Do I have to try something different?

Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

• Use concise, accurate thread titles.
  
• Your post title should describe your problem, not your anticipated solution.
• Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
• Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.

NAs you have fewer than 10 posts, I will help you out this time. Next time, you must provide a better title yourself. Thanks.

Try a double INDEX- MATCH: =INDEX($C$2:$F$21,MATCH($I$1&I2,INDEX($A$2:$A$21&$B$2:$B$21,0),0),MATCH($I$3,$C$1:$F$1,0))

What result are you expecting in the yellow box?

Try this:

=IFERROR(1/(1/INDEX($C$2:$F$21,MATCH(I1,$A$2:$A$21,0)+IF(I2="Night",1,0),MATCH(I3,$C$1:$F$1,0))),"")

Merged cells are a no-no!!!

=IF(ISBLANK(INDEX($C$2:$F$21,MATCH(I1,$A$2:$A$21,0)+IF(I2="Night",1,0),MATCH(I3,$C$1:$F$1,0))),"",INDEX($C$2:$F$21,MATCH(I1,$A$2:$A$21,0)+IF(I2="Night",1,0),MATCH(I3,$C$1:$F$1,0)))

Thank you all

What do you mean got you close? In what way does my formula fail?

You still need to stop using merged cells - they are more trouble than they are worth.