Index Match or Find Function Help

[kylenusser]

Hello. I am trying to compile a database and use some function to match the number of calls ran by date.

For example:

1/1/18		1/2/18
Facility A	15	Facility A	25
Facility B	20	Facility B	15
Facility C	30	Facility C	15
Facility D	20	Facility D	10
Facility E	8	Facility E	7
Facility F	9	Facility F	10
Facility G	5	Facility G	6
Facility H	8	Facility H	9
Facility I	10	Facility I	20

<tbody>
</tbody>

Above is a database of the first two days. I am trying to compile a sheet that has Facility A-F in column A and in Column B-Etc is each date from 1/1/18-12/31-18. I am trying to see if there is a function that will allow me to search the table above for say Facility A on 1/1/18. I want to set it to be able to pull any day, as the table will ultimately extend to 12/31/18.

Does anyone know of any functions that can do this?

 

[kylenusser]

Looks like that works. Thank you sir