Lookup on Multiple criteria in seperate table

[Gwill1983]

Hi all,

I am trying to create a staff planner whereby I add the new request into a table and the information pulls through into 3 seperate tables depending what the request is and what date the request is on. I will try my best to make it clear how this is setup.....

The 'requests' table is as below:

I then have 3 tables as below:

In each cell of each table I have the formula below:

{=IFERROR(INDEX(Requests[[#All],[Work From Home?]],MATCH(1,([@Staff]=Requests[[#All],[Staff Member]])*('Current Week'!G$9=Requests[[#All],[Date]]),0)),"")}

This works for the majority, but for some reason it doesnt pull through a result everytime!

I just wanted to see if anybody could spot the error in what I am doing as it is driving me loopy!!

 

[awoohaw]

can you anonymize the names and post a mini workbook using the xl2bb add in?
What is the error you're getting? and also give an example of the cell and the expected result?