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:

[TABLE="width: 500"]
<tbody>[TR]
[TD]1/1/18[/TD]
[TD][/TD]
[TD]1/2/18[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Facility A[/TD]
[TD]15[/TD]
[TD]Facility A[/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD]Facility B[/TD]
[TD]20
[/TD]
[TD]Facility B[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD]Facility C[/TD]
[TD]30[/TD]
[TD]Facility C[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD]Facility D[/TD]
[TD]20[/TD]
[TD]Facility D[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Facility E[/TD]
[TD]8[/TD]
[TD]Facility E[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]Facility F[/TD]
[TD]9[/TD]
[TD]Facility F[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Facility G[/TD]
[TD]5[/TD]
[TD]Facility G[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Facility H[/TD]
[TD]8[/TD]
[TD]Facility H[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]Facility I[/TD]
[TD]10[/TD]
[TD]Facility I[/TD]
[TD]20[/TD]
[/TR]
</tbody>[/TABLE]


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