find value in matrix (in other words: find value based on 2 criteria)

[Lander123]

Hi, i am trying to make excel Calc find a value in a table i have in the same spreadsheet, that matches 2 conditions.
I am trying to make Calc return the “maximum load value” of musical instrument strings based on “diameter” and “type”

My table looks like this:

diameter |     type    |  max. load

0,7_____________1_____________x

0,75____________2_____________x

0,8_____________1_____________x

etc.

The data, consisting of “max load values” looks like this:

diameter |     type 1    |   type 2 | type 3

0,7_____________500____________600____750

0,75____________550____________660____820

0,8_____________600____________710____870

etc.

how do i find “x”?

[mikekaganski]

If you have your data like this:

Sheet1

	A		B		C
1	0,7		1		<Formula>
2	0,75	2		<Formula>
3	0,8		1		<Formula>

Sheet2

	A		B		C		D
1	0,7		500		600		750
2	0,75	550		660		820
3	0,8		600		710		870

… then you can use this formula in Sheet1.C1: =VLOOKUP(A1;$Sheet2.$A$1:$D$3;B1+1;0)

[Lander123]

this works !

The index part of vlookup function is what i could not seem to figure out.
So, thanks for the help !

kind regards,
Lander