G
GaryS
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)
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)