Match two columns to two different criteria and provide a result from a third column

Hello,
I have two spreadsheets I am working with "Call Arrival Patterns" DBP Split Data". I want the Call Arrival Pattern spreadsheet to update once the DBP Split spreadsheet is updated. I need the formula to match the dates and the intervals and provide the "Calls Offered" in column C for the corresponding interval.

Column B of the Call Arrival Pattern lists the intervals by 30 minutes 00:00-24:00. Horizontally are the dates as each day is listed separately- so all Mondays listed together, all Tuesdays are listed together etc. The "Calls Offered" need to go to the right of the intervals.

1/23
0:00
0:30
1:00
1:30

From the DBP Split Data file the Dates are listed in Column A. Column B lists the Intervals and Column C lists the Calls Offered. The Calls Offered from this spreadsheet are what I need to get to populate in the Call Arrival Pattern spreadsheet.

Date Interval Calls Offered
1/23 0:00
1/23 0:30
1/23 1:00
1/23 1:30
1/23 2:00
1/23 2:30
1/23 3:00
1/23 3:30
1/23 4:00
1/23 4:30


I have tried =Index('[DBP Split Data.xls]Switch!'$C:$C,Match(S110,'[DBP Split Data.xls]Switch!'$A:$A,0)) I get #NA
I also tried =IF(And('[DBP Split Data.xls]Switch!'$A:$A=S110,'[DBP Split Data.xls]Switch!'$B:$B=B111,'[DBP Split Data.xls]Switch!'$C:$C,"")) Just a "This formula makes no sense" error on this one. lol

Any help would be greatly appreciated. Thank you for your time!

JBeets

I am sorry about not adding them before- they are attached.

Yes they are seperate workbooks. The DBP Split Data will be a rolling spreadsheet that updates daily that I want the Call Arrival Pattern Workbook to get the data from.

This is wonderful! Thank you very much- I am happy to do the work on this just needed pointing in the right direction! Much more involved than I thought it would be.

Again, I really appreciate your help!

Jodi

OK so apparently you had more faith in me than I deserved! I decided to make the formula a little simpiler by adding the DBP Split Data sheet to the Call Arrival Pattern Spreadsheet so that the formula didnt have to look for the other workbook to get the data. However when i put the formula in it still acts like it is looking on my drive for the location of another workbook and then I get a #Name error.

Here is the code I updated: =Index(‘DBP Split Data’!$C$9:$C$20000,Match(S$6&$B8,’DBP Split Data’!$A$9:$A$20000&’DBP Split Data’!$B$9:$B$20000,0))

I just cannot figure out what I did wrong this time. I see the one you did for me is working just fine! LOL Thank you in advance for your help!

Jbeets

I am so sorry- I thought they were still attached. Here they are-