View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre
 
Posts: n/a
Default Match, index,....

Try something like this:

M3: =INDEX(A1:D4,MATCH(M1,A1:D1,0),MATCH(M2,A1:A4,0))

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"JcR" wrote:

I have a matrix in cells A1 across to D1 and A1 down to a4 (16 cells)

It looks like this:
A B C D
1 5 6 7
2 8 M N O
3 9 P Q R
4 10 S T U

If i enter "6" in cell m1, and "9" into cell m2, i want resultant intersect
"Q" to appear in m3

If i enter "7" in cell m1, and "10" into cell m2, i want resultant intersect
"U" to appear in m3

Thanks very much