Jeppe,
If you table is in A1:D4, A11 has a 2, and A12 has b:
=INDEX(A1:D4,MATCH(A11,A1:A4,FALSE),MATCH(A12,A1:D 1,FALSE))
HTH,
Bernie
MS Excel MVP
"Jeppe" wrote in message
...
Below you see a matrix.
I want to give a function i.e. the letter b and the digist 2 and then
recieve the value 6,9...
***a* * * b* * *c*
*1* 0,5 0,2 0,5
*2 * 7,1 6,9 7,8
Which function can I use?
Thanks...
--
Jeppe
------------------------------------------------------------------------
Jeppe's Profile:
http://www.excelforum.com/member.php...o&userid=11218
View this thread: http://www.excelforum.com/showthread...hreadid=272406