Ok, we'll need some clarifications...

Is this what your table looks like:

...........A..........B..........C
1.................2009.....2008
2.................BGT......BGT
3.................TRN......TRN
4......JAN....100........301
5......FEB....101........401
6......MAR...201.......501

5 JAN 2009

Is that in 2 cells?

5 Jan
2009

Is 5 Jan a true Excel date?

Are the months in your table in a calender sequence Jan, Feb, Mar, Apr, May,
Jun, Jul, ... Dec

If BGT TRN is entered in every column then all you need to do is match the
year number.


--
Biff
Microsoft Excel MVP


"GaryS" wrote in message
...
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)