=INDEX(A1:D4,MATCH("BOS",A1:D1,0),MATCH(Datevalue( "2/2/06"),A1:D1,0))
(assuming 2/1, 2/2, 2/3 are real dates in 2006.
Bob Umlas
Excel MVP

"Curt D." wrote in message
...
Is there a formula or VBA coding that will allow me to serch a range that
has
a criteria for the row and another one by the column? For example I have

2/1 2/2 2/3
ATL 40 45 35
BOS 23 9 0
CVG 4 12 10

I need to search this range above and say I need the number for BOS on
2/2,
how could I do this? Any help would be appreciated. thanks