I'm trying to figure out a formula the would match a month on the verital
column and then three sets of critera in the horizontal column such as year
and two other words (BGT & TRN).

So for instance is I want to match the date and year from A5 & B5 plus the
words BGT & TRN in and return the value D5 from the above data and would
return 100.


A B C D
2009 2008
BGT BGT
TRN TRN
1 JAN 100 301
2 FEB 101 401
3 MAR 201 501


5 JAN 2009 * (Match the date from A5 & B5 with Value in C5)