Hi Jeppe

one way

assuming a, b, c are labels and not column headers (and 1,2 are labels & not
rows)

=INDEX(A1:D3,MATCH(2,A1:A3,0),MATCH("b",A1:D1,0))

if they are column headers and rows use

=INDEX(A1:C2,2,2)
where the first 2 is the row number and the second 2 is the column number of
the range specified in the first parameter.

Cheers
Julied

"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