View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default How to get the value in a matrix?

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