Good afternoon,

I need a formula that will perform a look up to pull me in information that has certain criteria downwards and across

Example

Column A = Dates
Column B1, C1, D1 Etc = Name Criteria
Column B2:Z300 = Value

So what I want is something like 
=SUMPRODUCT(A1:A300="01/06/14")*(B1:Z1="Criteria")*(B1:Z300
I know the above will not work but it explains what i am after,

Thanks in advance

DJ