View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David A. David A. is offline
external usenet poster
 
Posts: 64
Default I am trying to lookup a cell based upon what is in row 3 and colum

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.