Jeppe,

Here's one idea Using a combination of offset and match functions:

Define the range of your matrix as "rngDatabase"
Define the column containing the row header as "xCoordinate"
Define the row containing the column header as "yCoordinate"
Define the cell to contain your x criteria as "rngX_Value"
Define the cell to contain your y criteria as "rngY_Value"

Here's the formula (assumes headers are top row and left most column):
=OFFSET(rngDatabase,MATCH(rngX_Value,xCoordinate,0 )-1,MATCH(rngY_Value,yCoordinate,0)-1,1,1)

Dale Preuss

"Jeppe" wrote:


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