Assume you want to lookup names in A3:A29 and dates in A3:M3 then use 2
cells that are not part of it other wise you obviously are going to get the
wrong coordinates

=INDEX(A3:M29,MATCH(D1,A3:A29,0),MATCH(E1,A3:M3,0) )

where D1 holds the name and E1 the date, meaning that is the name is found
in A10 and the date in H3 then the value will be from H10


--
Regards,

Peo Sjoblom



"David A." wrote in message
...
I am trying to lookup a cell based upon what is in row 3 and column A. Lets
say in column A I have names, row 3 has a date. How do I get the cell that
intersect with those 2 things?

I have been playing with:
=INDEX(C3:M29,MATCH($A$4,A:A,0))&(MATCH($C$3,3:3,0 ))
but I can't figure this out.....

Help.
Thanx,
David.